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?