Amount in Thousand ?

's Computer Specifications

Hi there,

I'm trying to configure a format which shows me amounts in thousand ? ,e.g.
12600? = 13 oder 11300?= 11 usw.

Could somebody assist here please?

Thanks much
Mike

's Computer Specifications

Format/Cells/Number/Custom #,

In article <#(E-Mail Removed)>,
"Maik Richter" <(E-Mail Removed)> wrote:

> Hi there,
>
> I'm trying to configure a format which shows me amounts in thousand ? ,e.g.
> 12600? = 13 oder 11300?= 11 usw.
>
> Could somebody assist here please?
>
> Thanks much
> Mike

's Computer Specifications

Mike,

Use the custom format

0,

HTH,
Bernie
MS Excel MVP

"Maik Richter" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi there,
>
> I'm trying to configure a format which shows me amounts in thousand ? ,e.g. 12600? = 13 oder
> 11300?= 11 usw.
>
> Could somebody assist here please?
>
> Thanks much
> Mike
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate the amount of time over a permitted amount (12 hours)	Steve M	Microsoft Excel Misc	7	2nd Jun 2010 12:19 PM
Re: how can i round a dollar amount to the nearest thousand?	joeu2004@hotmail.com	Microsoft Excel Worksheet Functions	0	22nd Jan 2007 08:06 PM
Formula for amount owing subtract amount paid	=?Utf-8?B?VGFwZXJjaGFydA==?=	Microsoft Excel Worksheet Functions	1	4th Jun 2006 05:51 PM
How can I calculate amount of time left based on amount spent?	=?Utf-8?B?S0xE?=	Microsoft Excel Worksheet Functions	3	23rd May 2006 04:20 PM
limiting subform amount to amount of main form	=?Utf-8?B?bWhtYWlk?=	Microsoft Access Getting Started	1	8th Sep 2005 03:36 PM