Forum Discussion
Excel number format - doesn't read as a number
I have a problem with an excel sheet where some of the numbers look like a number with no decimals and with 1000 separator. Excel doesn't read this as number and it is impossible to change format. I ...
It looks like initially cells were in text format and cell values were shown as text. Just changing the cell format to General or Number is not enough, in addition values are to be re-entered.
If data is in the column, after changing the format you may Data->Text to Columns->Finish.
Alternatively select Paste Special->Operations->Add zero to all cells in question.