Forum Discussion
why i can't convert my excel data to number.
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
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
- NikolinoDEGold Contributor
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.
Nikolino
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