office 365 EXCEL UK CURRENCY HELP PLEASE
Hi
I'm having trouble with the office 365 version of excel formatting to UK currency
excel formats my uk currency as £120,50 ( to represent £120 and 50 pence) whereas I want to format it like i could in earlier versions of excel as
£120.50
I cant seem to be able to find any option anywhere to change commas to periods - i can find info online for some earlier versions but not for office 365 EXCEL
please help
tony
Are you using the desktop version or the browser-based version? If the former, File | Options | Advanced ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
That is usually controlled by your operating system's region setting. Not by Excel (for desktop installation).
Check Control Panel-> Region and Language->Formats->Additional settings.
Find "Decimal Symbol" and change as needed.
Edit: For online, it may be controlled by your administrator for Enterprise/corporate subscription. You may need them to change region setting for the account/domain.
Last edited by CK76; 07-12-2017 at 11:42 AM. Reason: See Edit:
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
See post #2 - it can be changed within Excel.Not by Excel (for desktop installation).
Ah, I stand corrected. Never realized I always had Use system checked
It's usually governed by the system set-up, I agree.
Re: office 365 EXCEL UK CURRENCY HELP PLEASE
Many thanks guys!
For some strange reason my regional settings had changed from UK Spain!
All sorted thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks