View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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