+ Reply to Thread
Results 1 to 2 of 2

Changing from norwegian to english numbering format

  1. #1
    Registered User
    Join Date
    10-08-2011
    Location
    Oslo
    MS-Off Ver
    Excel 2007
    Posts
    35

    Changing from norwegian to english numbering format

    Hi Guys,

    Hope someone can help me.

    I have several graphs in excel which has the percentage number as follows: 15,5 %. I want to convert the number to 15.5 % so it is in line with the english language.

    Can someone please help me?

  2. #2
    Registered User
    Join Date
    12-21-2011
    Location
    EU here and there
    MS-Off Ver
    Excel 2019
    Posts
    69

    Re: Changing from norwegian to english numbering format

    Quote Originally Posted by RKP View Post
    Hi Guys,

    Hope someone can help me.

    I have several graphs in excel which has the percentage number as follows: 15,5 %. I want to convert the number to 15.5 % so it is in line with the english language.

    Can someone please help me?
    I would have thought that this is set dynamically in Excel based on your Windows settings.

    Try opening up Regional Settings in the Control panel (it's called something along those lines, used to be "Regional Settings" in XP - I'm sure you can find it).

    If your machine has an English operating system, then you will get the "." as the decimal point.
    If you have Norwegian or most other continental European OS, you get "," as default.

    However you can override this by changing individual settings, like date format, decimal point 24 hour vs a.m/p.m and much more.

    For example if you are running English Windows but you are in Norway, you might want to tweak your settings to suit your situation, i.e still have the Norwegian settings that are familiar, despite the actual OS being in English.

    A note on this: Bear in mind also that the UK English settings are much more similar to continental European, than the US which is quite different and can be irritating and confusing. So don't choose US settings unless you are familiar with the differences which are quite significant.

    In Excel, you can change this by right clicking on the cells and selecting Format,
    then check the settings carefully and you will see it.

    The other place to check is Excel options, and Language, plus Advanced sections.

    I divide my time between the UK and Sweden, but I set the machine up to be 100% UK because all this can be quite frustrating and can cause confusion if you are not paying attention.
    Last edited by johanna0507; 11-06-2013 at 10:39 AM.

+ 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. [SOLVED] Changing case to English Style in a Macro
    By jshaw82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2013, 02:52 PM
  2. English to English Dictionary in MS Excel format
    By waqaszhr in forum Excel General
    Replies: 0
    Last Post: 12-03-2012, 03:19 PM
  3. Convert Norwegian currency formatting to US/UK
    By happycats in forum Excel General
    Replies: 3
    Last Post: 11-04-2011, 05:03 PM
  4. convert excel formulas from english to norwegian
    By Ctech in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-21-2006, 12:55 PM
  5. Date Format - US to English
    By Eggtavius in forum Excel General
    Replies: 6
    Last Post: 01-30-2006, 04:10 PM

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