View Single Post
 
Old 08-18-2012, 01:15 AM
Catalin.B Catalin.B is offline Windows Vista Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Quote:
Originally Posted by Metamag View Post
Also under system separator of course I changed to comma for both decimal and thousands the first time.
That's the point where the problem starts..
If you check the custom category, the format you used when you used comma for both separators , even for currency, is saved there... it will look like : [$$-409]#,##0,00 for US dollars. Means that every time you use currency format, excel will use this custom format.
You should delete this format from the list, otherwise this is the format excel will use when you format to currency.

You should learn more about formatting before saying that "Nothing you said is relevant". From what i see, you understood nothing from what i said.

Just go to advanced options, use different separators for decimal and thousands, then in the custom formats list, select the wrong formats and delete them so they will not be automatically used to format the currency .
Reply With Quote