confine cells to two digits

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hoysala - 25 Jan 2008 19:28 GMT

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?

Reply to this Message

Per Jessen - 25 Jan 2008 19:37 GMT

Hi

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

Regards,

Per

> hi all,
>
[quoted text clipped - 6 lines]
>
> but what can be done to make 5 to 05?

Reply to this Message

hoysala - 25 Jan 2008 19:44 GMT

> Hi
>
[quoted text clipped - 16 lines]
>
> - Show quoted text -

thanks a lot

Reply to this Message

Jim Thomlinson - 25 Jan 2008 19:40 GMT

format the cell with a custom format of 00

Signature

HTH...

Jim Thomlinson

> hi all,
>
[quoted text clipped - 6 lines]
>
> but what can be done to make 5 to 05?

Reply to this Message