+ Reply to Thread
Results 1 to 3 of 3

Comma in Dot in Figures

  1. #1
    Registered User
    Join Date
    01-26-2010
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    37

    Arrow Comma in Dot in Figures

    Hi,

    I have a German Windows 7 but Office 2007 in English. I changed the option that Excel should not use system seperators. So when I type in numbers excel uses the UK seperators e.g. 5,241.33 instead of 5.241,33. However, in my diagramm it uses still the German seperators, so I have numbers like 8,43% instead of 8.43%. In my spreadsheet from where the diagram takes the data it is correct = 8.43%.

    I don't know what to do. Can anyone help me how to change this?

    I appreciate your help.

    Cheers
    Last edited by DonkeyOte; 01-27-2010 at 04:17 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Comma in Dot in Figures

    epione, please take care when spelling - I'm assuming your spelling of spreadsheet was an oversight (since corrected) - if not, do not repeat.

  3. #3
    Registered User
    Join Date
    01-26-2010
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: Comma in Dot in Figures

    Yes, that what I am saying yayahoho.

    I made a screenshot. See how I have the english formatted % figures with a dot as seperator and in the diagram it is still a comma seperator.

    http://img5.imagebanana.com/img/dge23au0/commadot.jpg

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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