Just custom format as
000

--
Don Guillett
SalesAid Software

"Dave" wrote in message
. uk...
Hi all, I know its not really related to vb, but its fairly simple. How I
make a number in a cell always be 3 digits long, or how do I make it so
that
when a value like 9 is entered it changes to 009 or 045 etc.
Dave