scale graph number shows as 2"500'000 but need to change it to 2"500
I am working on a graph and the scale graph number shows as 2"500'000
but I need to edit it to show 2"500
the current custom number setting is [>=1000000]#''000'000;[<=-1000000]-#''000'000;#'000
i tried [>=1000000]#''000;[<=-1000000]-#''000;#'000 but it changes to 2500"000
Replace ''000'000 with dot/comma
Try this:
[>=1000000]''#.;[<=-1000000]-#.'';#.''