confine cells to two digits

's Computer Specifications

hi all,

i need to confine the content of column j to 2 digitts

i want to limit the column < 100, and also if i enter 5 should become
05

the limits can be done in data validation,

but what can be done to make 5 to 05?

's Computer Specifications

Hi

Select the column > Format cells > Number > Custom > ##00 > OK

Regards,

Per

"hoysala" <(E-Mail Removed)> skrev i en meddelelse
news:8ca499f2-377e-4c96-a4c9-(E-Mail Removed)...
>
> hi all,
>
> i need to confine the content of column j to 2 digitts
>
> i want to limit the column < 100, and also if i enter 5 should become
> 05
>
> the limits can be done in data validation,
>
> but what can be done to make 5 to 05?

's Computer Specifications

format the cell with a custom format of 00
--
HTH...

Jim Thomlinson

"hoysala" wrote:

>
> hi all,
>
> i need to confine the content of column j to 2 digitts
>
> i want to limit the column < 100, and also if i enter 5 should become
> 05
>
> the limits can be done in data validation,
>
> but what can be done to make 5 to 05?
>

's Computer Specifications

On Jan 26, 12:37*am, "Per Jessen" <per.jes...@mail.dk> wrote:
> Hi
>
> Select the column > Format cells > Number > Custom > ##00 > OK
>
> Regards,
>
> Per
>
> "hoysala" <rshashidh...@gmail.com> skrev i en meddelelsenews:8ca499f2-377e-4c96-a4c9-(E-Mail Removed)...
>
>
>
>
>
> > hi all,
>
> > i need to confine the content of column j to 2 digitts
>
> > i want to limit the column < 100, and also if i enter 5 should become
> > 05
>
> > the limits can be done in data validation,
>
> > but what can be done to make 5 to 05?- Hide quoted text -
>
> - Show quoted text -

thanks a lot

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove first few digits from all cells in the column	=?Utf-8?B?TWFnd2luZQ==?=	Microsoft Excel Worksheet Functions	7	2nd Aug 2007 10:39 PM
Format cells to always have 13 digits?	=?Utf-8?B?Q2hyaXN0aW5l?=	Microsoft Excel Worksheet Functions	2	30th Jan 2007 10:33 PM
Getting the first 3 digits out of 6 digit cells?	=?Utf-8?B?RGFybGE=?=	Microsoft Excel Worksheet Functions	5	15th Sep 2005 03:08 PM
Re: counting digits inside cells	Chewy667	Microsoft Excel Misc	0	31st Aug 2004 01:58 PM
Digits in Cells been automatically divided by 100.	Helen Chen	Microsoft Excel Misc	0	22nd Jul 2003 06:55 AM