why i can't convert my excel data to number.

Occasional Contributor

Hi All,


I am trying to make total(sum) of my row(Unweighted Rev) but its not changing please help me any one i attached my file

2 Replies



Enclosed Sheet and further down information on how to do it.

To cancel a selection of cells, click any cell on the worksheet.

Next to the selected cell or range of cells, click the error button that appears.

On the menu, click Convert to Number. (If you want to simply get rid of the error indicator without converting the number, click Ignore Error.)

This action converts the numbers that are stored as text back to numbers.

Once you have converted the numbers formatted as text into regular numbers, you can change the way the numbers appear in the cells by applying or customizing a number format. For more information, see Available number formats.



The file has been corrected as required.

Fix text-formatted numbers by applying a number format


I would be happy to know if I could help.



I know I don't know anything (Socrates)


* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here



Depends on your regional settings. As variant you may try

select column

Data->Text to Columns

On first step Fixed width

On third step of the wizard select