View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default how to display numbers in thousands i.e display 10,000 as 10

Format Custom as #, (end with a comma)

--
Kind regards,

Niek Otten

"excel2002" wrote in message ...
| Is there any quick way to display a list of numbers in thousands? for
| instance, how to change the display of 10,000 into 10 other than put in a
| formula of 10,000/1000?
|
| Thanks a lot!