confine cells to two digits

  • Thread starter Thread starter hoysala
  • Start date Start date
H

hoysala

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?
 
Hi

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

Regards,

Per
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Confine Cell to Proper Case 2
Copy row to new sheet if cell data is repeated more than 3 times 2
confine text to cell 4
President of Microsoft calls for 'digital Geneva convention' 0
Compating all rows in two sheets 2
VLook up question 2
comparing two columns in vba 2
VBA set thick borders around non empty cells in range 0

Back
Top