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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
strange currency format behaviour
Excel Facts
Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Similar threads
- Replies
- 1
- Views
- 532
- Question
- Replies
- 2
- Views
- 349
- Solved
- Replies
- 1
- Views
- 843
- Replies
- 2
- Views
- 1K
- Replies
- 2
- Views
- 447
