Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
number ZERO in a cell
hi,
I have a cell that i want a user to enter a number into. BUT... u know how if you enter '0123' it will change it to '123' ... how can i KEEP the '0' at the beginning of the number |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
number ZERO in a cell
If you want the cell value to always be 4 digits with a leading zero just format the cell the be four digits: Format Number Custom Type: 000 -- sdblac ----------------------------------------------------------------------- sdblack's Profile: http://www.excelforum.com/member.php...fo&userid=1469 View this thread: http://www.excelforum.com/showthread.php?threadid=26318 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
number ZERO in a cell
enter it as
'0123 (it is now text) or format the cell as text before entry or if you want a number and it will always be 4 digits, format the cell with a custom number format of 0000 -- Regards, Tom Ogilvy wrote in message ... hi, I have a cell that i want a user to enter a number into. BUT... u know how if you enter '0123' it will change it to '123' ... how can i KEEP the '0' at the beginning of the number |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
command to return the row number or cell number in excel? | Excel Programming |