Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom Number formatting
Hi guys,
I have a bunch of big numbers 1'000'000, 900'000 etc... and would like to format them in order to cut last 3 zeros (for chart visualisation purposes). I suppose that the adequate formatting could be something like #.##/1000, but this one is not working.. Could you pls help me on this? Thanx, |
#2
|
|||
|
|||
Try (US format, adjust to suit):
#,##0, In article , "gizmo" wrote: I have a bunch of big numbers 1'000'000, 900'000 etc... and would like to format them in order to cut last 3 zeros (for chart visualisation purposes). I suppose that the adequate formatting could be something like #.##/1000, but this one is not working.. |
#3
|
|||
|
|||
Thanks a lot for your suggestion!
The format you suggested replaced "1'000'000" by "1000,000," (which was probably due to my comp's settings), but then I've found (by trial and error, inspired by your input) the one that is fuctionning perfectly (giving simply "1000"). In my case it was #' Cheers, Gizmo "JE McGimpsey" wrote in message ... Try (US format, adjust to suit): #,##0, In article , "gizmo" wrote: I have a bunch of big numbers 1'000'000, 900'000 etc... and would like to format them in order to cut last 3 zeros (for chart visualisation purposes). I suppose that the adequate formatting could be something like #.##/1000, but this one is not working.. |
#4
|
|||
|
|||
Hi,
Just for the record; here are two good sources: http://www.mvps.org/dmcritchie/excel....htm#getformat http://support.microsoft.com/?scid=k...d=1743&sid=340 And examples how to use it: # # : 1 000 000 (#blank#) # # ' : 1 000' (#blank#blank') # '' : 1'' (#blankblank'') that is two ' + #.### ' : 1.000' Ola |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formatting a number | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |