+ Reply to Thread
Results 1 to 7 of 7

office 365 EXCEL UK CURRENCY HELP PLEASE

  1. #1
    Registered User
    Join Date
    07-12-2017
    Location
    England
    MS-Off Ver
    0ffice 365
    Posts
    2

    Question 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

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,416

    Re: office 365 EXCEL UK CURRENCY HELP PLEASE

    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: office 365 EXCEL UK CURRENCY HELP PLEASE

    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

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,416

    Re: office 365 EXCEL UK CURRENCY HELP PLEASE

    Not by Excel (for desktop installation).
    See post #2 - it can be changed within Excel.

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: office 365 EXCEL UK CURRENCY HELP PLEASE

    Ah, I stand corrected. Never realized I always had Use system checked

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,416

    Re: office 365 EXCEL UK CURRENCY HELP PLEASE

    It's usually governed by the system set-up, I agree.

  7. #7
    Registered User
    Join Date
    07-12-2017
    Location
    England
    MS-Off Ver
    0ffice 365
    Posts
    2

    Red face 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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 12-18-2016, 11:47 PM
  2. Replies: 1
    Last Post: 08-07-2016, 05:52 PM
  3. Replies: 7
    Last Post: 06-17-2014, 02:15 PM
  4. Replies: 4
    Last Post: 05-02-2010, 12:05 PM
  5. [SOLVED] Merging excel office data into a publisher office project(Australi
    By Shirl in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 04-16-2006, 04:20 AM
  6. Replies: 2
    Last Post: 03-21-2006, 06:00 PM
  7. Replies: 5
    Last Post: 06-24-2005, 03:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1