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

"TD8953" wrote in message
...
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.

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

In article ,
TD8953 wrote:

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.