confine cells to two digits
 

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?

confine cells to two digits
 

Hi

Select the column Format cells Number Custom ##00 OK

Regards,

Per


"hoysala" skrev i en meddelelse
...

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?

confine cells to two digits
 

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?

confine cells to two digits
 

On Jan 26, 12:37*am, "Per Jessen" wrote:
Hi

Select the column Format cells Number Custom ##00 OK

Regards,

Per

"hoysala" skrev i en ...





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