Number displays

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

 

[Nick]

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

 

[JE McGimpsey]

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