how to display numbers in thousands i.e display 10,000 as 10
Hilight the cells that you want to display in thousands.
Follow the Excel menu path Format / Cells.
On the format cells dialogue box choose the Numbers tab.
Choose the Custom category.
Type #, in the Type box.
Click Ok.
Whatever value you now enter in those cells should be displayed in thousands
(Ex. 1,000 will show up as 1).
"excel2002" wrote:
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!
|