| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function result losing leading zeros
I am merging two custom values "0000" together with a dash, and the result
loses the leading zeros. Ex. 0001 and 0101 end up as 1-101 and I want it to be 0001-0101. Note*The number of leading zeros changes since I have a huge list of values, so I can't just add the 3 and 1 zero(s) needed in this example. using formula =(F7&"-"&G7) AND Custom Format 0000 in the two previous columns to the function column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mail merge in excel/losing leading zero | Excel Discussion (Misc queries) | |||
| zip codes without losing leading zero from csv | Excel Discussion (Misc queries) | |||
| keep leading zeros when using the paste spec. multiply function | Excel Discussion (Misc queries) | |||
| LEADING ZEROS IN FORMULA RESULT | Excel Worksheet Functions | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Threaded Mode
