cell settings
Data|Validation
Settings:
Allow: Whole Number
I would select between 0 and 99 (or -99 and 99 if you allow negatives).
Then format the cell, custom as 00
--
John C
"jaz" wrote:
hello there
is there a way that a cell can be set to no more then 2 digits
eg, should accept 01,02 and not 001 or 002
many thanks
jez
|