Currency symbol inccorect

[Guest]

Hi
If i click the currency button I get 7,928.00 $
If i manualy format the cell I can get the correct correct currency R 7,928.00

I have the correct settings in regional settings in the control panel.
I have to set the symbol everytime I format manually.

How do I set it that the currency button uses the correct formatting?

 

[Norman Harker]

Hi ceaza!

It still seems like you have a Regional settings problem.

Make sure on the currency tab you select exactly what you want.

Then click "Apply" and not OK

I recall that in some cases a shut down and re-boot was necessary
before they took effect even if this wasn't indicated.

 

[Gord Dibben]

ceaza

The currency button gets its formatting from Format>Style>Currency.

Make the changes there under "Modify".

Gord Dibben Excel MVP

 

[Guest]

Thank norman will try and let you know.

Regards
ceaza