View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default 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!