Forum Discussion
Impossible to sum numbers in Excel
Went into your sheet and when I select each cell in column C and press enter in the formula bar, the left justified text becomes a number. Also added a formula in column D to demonstrate what I wrote in my previous message.
Thank you! Is there any way to make this a default?
I've had many versions of Excel and this is the first time I have to go through all these steps for it to recognize text as a number (!)... Isn't that the point of Excel? 🙂If you enter a valid number in any cell, the excel will recognize it as a number.
Normally it happens when you copy the data from external source and paste it into excel.
Depends where your "numbers" come from. Importing them could cause them to be text. Just entering them them from scratch should, by default, recognise them as numbers.
Riny_van_Eekelen these were all manually entered... which is so strange... is there something wrong in my settings? I should have to tell it every time that it's a number, right?
