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

Niek,

Can you be more specific on how to get there step by step? Reeeeally
appreciate your quick answer.

"Niek Otten" wrote:

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!