Forum Discussion
Issue with currency automatically changing to dollars
PeterR_TS Unless specifically set, the currency format is taken from the user's international settings. If you've used the Currency button on Excel's Start tab, that is precisely what happens. What you want to do is format the cells with a currency to a specific currency type:
PeterR_TS Unless specifically set, the currency format is taken from the user's international settings. If you've used the Currency button on Excel's Start tab, that is precisely what happens. What you want to do is format the cells with a currency to a specific currency type:
JKPieterse great! that makes sense. thanks
@Pete
I found that after an update, the Region settings had been changed from English (United Kingdom) to English (United States).
Once this was changed back, all of my spreadsheet currency changed back to £. Odd that!!!
