You are correct, which is why it is formatted as 00 instead of 000,
therefore, even if they enter 001 it will only show as 01.
--
John C


"David Biddulph" wrote:

But 001 and 0001 are between 0 and 99, so that won't do the trick, John.
--
David Biddulph

"John C" <johnc@stateofdenial wrote in message
...
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