software

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!

Format Custom as #, (end with a comma)

--
Kind regards,

Niek Otten

quot;excel2002quot; gt; 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!
Niek,

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

quot;Niek Ottenquot; wrote:

gt; Format Custom as #, (end with a comma)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;excel2002quot; gt; wrote in message ...
gt; | Is there any quick way to display a list of numbers in thousands? for
gt; | instance, how to change the display of 10,000 into 10 other than put in a
gt; | formula of 10,000/1000?
gt; |
gt; | Thanks a lot!
gt;
gt;
gt;

I got it!!! It is incredible! Thank you so much!

quot;excel2002quot; wrote:

gt; Niek,
gt;
gt; Can you be more specific on how to get there step by step? Reeeeally
gt; appreciate your quick answer.
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt; gt; Format Custom as #, (end with a comma)
gt; gt;
gt; gt; --
gt; gt; Kind regards,
gt; gt;
gt; gt; Niek Otten
gt; gt;
gt; gt; quot;excel2002quot; gt; wrote in message ...
gt; gt; | Is there any quick way to display a list of numbers in thousands? for
gt; gt; | instance, how to change the display of 10,000 into 10 other than put in a
gt; gt; | formula of 10,000/1000?
gt; gt; |
gt; gt; | Thanks a lot!
gt; gt;
gt; gt;
gt; gt;

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).

quot;excel2002quot; wrote:

gt; Niek,
gt;
gt; Can you be more specific on how to get there step by step? Reeeeally
gt; appreciate your quick answer.
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt; gt; Format Custom as #, (end with a comma)
gt; gt;
gt; gt; --
gt; gt; Kind regards,
gt; gt;
gt; gt; Niek Otten
gt; gt;
gt; gt; quot;excel2002quot; gt; wrote in message ...
gt; gt; | Is there any quick way to display a list of numbers in thousands? for
gt; gt; | instance, how to change the display of 10,000 into 10 other than put in a
gt; gt; | formula of 10,000/1000?
gt; gt; |
gt; gt; | Thanks a lot!
gt; gt;
gt; gt;
gt; gt;