Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|