Forum Discussion
Excel not formatting correctly even at cell level technical issue
Hi I have been passed here by the online chat support section as they have told me I have a technical issue. I am using my excel on this pc for the first time and I think I have had a problem on ...
thanks here is the version
Version : 18.2008.12711.0
and attached a copy onto a new worksheet of some of the data .
many thanks for your help
Please check your regional settings, perhaps decimal symbol on your PC is comma, not dot. You may Win+R, type control international, Enter, Additional settings, Numbers, Decimal symbol.
In the file all numbers are entered as texts, thus SUM() returns zero - it ignores all texts. You may convert them column by column to numbers using Data->Text to Columns, but first better to understand what is correct format for numbers in your PC. Try 1.23 and 1,23 - number will be aligned to the right, and text to the left.