Excel not formatting correctly even at cell level technical issue

binkyboo 

With 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.