Currency symbol inccorect

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
ceaza

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

Make the changes there under "Modify".

Gord Dibben Excel MVP
 
Back
Top