how do I display number in thousands; i.e diplay 123,500 as 124?
 

how do I display a list of numbers in thousands? For instance, how to diplay
123,500 as 124 in a quick way, instead of putting formular of 123,500/1000?

Thanks!

how do I display number in thousands; i.e diplay 123,500 as 124?
 

format the cell like so

#,##0,_),(#,##0,)

"excel2002" wrote:

how do I display a list of numbers in thousands? For instance, how to diplay
123,500 as 124 in a quick way, instead of putting formular of 123,500/1000?

Thanks!