Forum Discussion
Solved
Issue with currency automatically changing to dollars
I'm finding that the currency for a whole sheet automatically changes from £pounds to $dollars. This doesn't happen to the whole workbook, This change happens to all currency formatted cells to an...
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!!!