Thread: confine cells to two digits
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hoysala hoysala is offline
external usenet poster
  
Posts: 11
Default 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?
Reply With QuoteReply With Quote