Thread: Number displays
View Single Post
  #1   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.