Forum Discussion
Excel not formatting correctly even at cell level technical issue
nce the possibilities in Excel are very diverse, the possible sources of error (not necessarily to be looked for in Excel) are also diverse.
Therefore, with your permission, please download a file (without sensitive data) with this problem so that the error can be reconstructed.
At the same time, I would ask you to name the Excel version and the operating system, as there may be different approaches to the proposed solution.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
thanks here is the version
Version : 18.2008.12711.0and attached a copy onto a new worksheet of some of the data .many thanks for your helpWith the permission of everyone involved, here is an additional route to your goal
How to switch to English numbers
Go to the File - Options - Advanced dialog.
In the first area, editing options,
switch off the default setting Use separators from operating system
and then enter the desired characters below.
To change to an English or American representation, simply exchange the content of the two fields:
How to switch to English numbers.
Don't forget to undo this setting for normal tables.
To do this, all you have to do is tick the box again, and the program will take over the country settings of your Windows.
From now on, English numbers will no longer be used, but the representation you would otherwise use.
If you then change the period with a comma in the numbers in the cells of your file, you will see the currency symbol.
In the file you should see the change in cell A1, it is correct for me.
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.
I'd do not recommend to change Excel settings on different from OS one to avoid extra headache.
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.
