Remember Me?

#1
April 26th 06, 07:28 PM posted to microsoft.public.excel.worksheet.functions
 excel2002 Posts: n/a
how to display numbers in thousands i.e display 10,000 as 10

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!

#2
April 26th 06, 07:37 PM posted to microsoft.public.excel.worksheet.functions
 Niek Otten Posts: n/a
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!

#3
April 26th 06, 07:44 PM posted to microsoft.public.excel.worksheet.functions
 excel2002 Posts: n/a
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

"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!

#4
April 26th 06, 07:52 PM posted to microsoft.public.excel.worksheet.functions
 excel2002 Posts: n/a
how to display numbers in thousands i.e display 10,000 as 10

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

"excel2002" wrote:

Niek,

Can you be more specific on how to get there step by step? Reeeeally

"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!

#5
April 26th 06, 07:53 PM posted to microsoft.public.excel.worksheet.functions
 William Horton Posts: n/a
how to display numbers in thousands i.e display 10,000 as 10

Hilight the cells that you want to display in thousands.
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

"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!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post excel2002 Excel Worksheet Functions 1 April 20th 06 06:31 PM Barb Excel Discussion (Misc queries) 0 February 6th 06 10:34 PM bpeltzer Excel Discussion (Misc queries) 0 February 6th 06 10:30 PM Steve Excel Discussion (Misc queries) 3 December 16th 04 11:21 PM texcel Excel Worksheet Functions 1 November 1st 04 06:38 PM

All times are GMT +1. The time now is 07:29 PM.