Number displays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I display a number in thousands or millions without rounding the
number? For example, I would like to see 52,569,832 displayed as 52,569.
 
Format the cell with a custom format
To display in thousands format as #,;-#, (hash comma semicolon)
To display in millions format as #,,;-#,, (hash comma comma semicolon)

Hope this helps.

Nick
 
You can't round down like that, but if you use

Format/Cells/Number/Custom #,##0,

then

52,569,832

will display as

52,570
 
Back
Top