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 th...
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.
- On my old PC my data would fill the columns correctly when importing but now I need do Text to column. If I clear all delimiters the data remains in one column.
Would be great if you know how I can import so it automatically fills the coloumns , would probably solve all issues.- It depends on the source of your data. It appears the source is coming from outside of Office 365. When this is the case, Excel will often pull in the data and evaluate a column of numbers as text. If the data is not filling out into columns it may be missing a delimiter.
- It makes no sence to me, on my old PC (from the same data souce) it fills out correcly but on my new PC it does not, they are both set to comma as the list separator.