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..
|