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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically prefix cell entry with leading zeros
Let's say:
A1: contain 123 B1: contain 456 In C1: =A1&B1 "Automatic prefix set with leading zeros" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically prefix cell entry with leading zeros
Use the text function, or set the column format to text.
with the function, change the 4 zeroes below to the number of digits there will be =TEXT(A1,"0000") -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Automatic prefix set with leading zeros" wrote: 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 |
Reply |
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) |