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 "£".

Here's a video to show you how (click on the YouTube logo to open it in full-screen):


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

1. In Windows 10 click on the Windows button and type 'Currency' and click on 'Change the way currency is displayed'.  In Windows 7 & 8 click on 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