strange currency format behaviour

jhitch

New Member
Joined
Apr 15, 2010
Messages
1
My default currency is £. I have a column of numbers formatted to £. the next column is a formula that multiplies the £ column by the exchange rate for Brazilian reais R$. When i format that column to R$ the first column changes the format to £$,that is a pound sign followed by a dollar sign! The default currency is also changed to £$ and will stay like that until i exit Excel and open again. This is true on all our school computers running Excel 2003 sp3 and XP sp3. Any ideas anyone?
 

Forum statistics

Threads
1,226,907
Messages
6,193,601
Members
453,810
Latest member
Gks77117

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top