shows as 2"500'000 but I need to edit it so it will show 2"500 instead

[Elainefish]

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

Please help

Thanks in advance

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-char...for-graph.html
Thread Closed.