Forum Discussion
Calculation result always 0
Hi, I have changed computers and now my excel is operating differenlty.
On a regular basis, I download data from my web app and do simple formulars to add cloumns up.
On the new PC when doing so the formaula result is always 0, I have checked that the format is General and the calculation option is on Automatic but the issue persists. If I retype the values in the next column and add the formula I get the correct result. It is as if excel is not seeing my imported vaules as numbers, please help.
6 Replies
Maybe your numbers are formatted as text. If so there is a green triangle in the left upper corner of the cell which is a notification of a possible error. In addition text is left-aligned in a cell whereas numbers are right-aligned in a cell.
Instead of retyping you can apply this formula:
=NUMBERVALUE(D3)Thanks for the reply. The numbers are left aligned, I have tried changing it to number format (and it shows that it is number formatted) but still will not add up my column, and no notification
of possible error.
Not sure where else to chage the format?
Select column E:E
Data | Text to columns, pick delimited, in the next step clear all delimiters and proceed by clicking next then finish.
