Using your Language and Currency format in Results Summary spreadsheet

Some international purchasers of the Results Summary spreadsheet have asked me how they can display their results with their country's currency symbol instead of "£".



Firstly, before you launch Excel (make sure you don't have any other spreadsheets you use open either):

1. Start button Picture of the Start button > Control Panel > Regional and Language Options > Formats (tab) > Current Format > English (United Kingdom).  Then click "Apply".
(It seems to be significant to select UK because the spreadsheet was originally created under these settings).



2. Launch your copy of Results Summary spreadsheet
3. Start button Picture of the Start button > Control Panel > Regional and Language Options > Formats (tab) > Current Format > your language / country.  Then click "Apply".


That's it!

No comments:

Post a Comment