Whenever I place a numeric value in a cell, it applies a currency format with the British pound sign.
Given that most of my input is in Australian dollars, I would prefer that the default is $.
How do I change this? My settings in Windows Control Panel are in Australian dollars but Excel insists in inserting the English pound sign, suggesting that my problem rests with a setting I have in Excel.
Thanks
Given that most of my input is in Australian dollars, I would prefer that the default is $.
How do I change this? My settings in Windows Control Panel are in Australian dollars but Excel insists in inserting the English pound sign, suggesting that my problem rests with a setting I have in Excel.
Thanks