0number
 

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

0number
 

Hi
if only the display is relevant use a custom format such as
000

--
Regards
Frank Kabel
Frankfurt, Germany
"Dave" schrieb im Newsbeitrag
. 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

0number
 

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