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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

excel2002 - 20 Apr 2006 18:26 GMT

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!

Reply to this Message

Duke Carey - 20 Apr 2006 18:31 GMT

format the cell like so

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

> 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!

Reply to this Message