+ Reply to Thread
Results 1 to 2 of 2

number scales for graph : shows as 2"500'000 but I need to edit it so it will show 2"500

  1. #1
    Forum Contributor
    Join Date
    02-16-2012
    Location
    Denmark
    MS-Off Ver
    O365
    Posts
    256

    number scales for graph : shows as 2"500'000 but I need to edit it so it will show 2"500

    Hi,

    Here is just a part of the graph that I am working on
    (sorry I cant give you the excel sheet because the documents are confidential)
    as you can see the scales in the left side are shown as 2"500'000 but I need to edit it so it will show 2"500 instead.
    the current number settings is [>=1000000]#''000'000;[<=-1000000]-#''000'000;#'000
    i tried [>=1000000]#''000;[<=-1000000]-#''000;#'000 but it changes to 2500"000
    Please help

    Thanks in advance
    Attached Images Attached Images
    Last edited by Elainefish; 05-06-2013 at 04:48 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: number scales for graph : shows as 2"500'000 but I need to edit it so it will show 2"5

    You could always post an example workbook without confidential data in it.

    try number format

    #,##0,
    Cheers
    Andy
    www.andypope.info

+ 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