Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically prefix cell entry with leading zeros
Hi,
I am trying to setup a prefix where I have a set number starting out but need to add additional numbers.. I have the format down to do that but is there a way to keep the leading zeros displayed since some of the numbers I have start with zeros... Example 123 is the set number and i want to add 00456... correct result 123456 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically prefix cell entry | Excel Worksheet Functions | |||
format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
Format a cell to keep leading zeros. | New Users to Excel | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |