| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I concatenate text with leading zeros
When I concatenate a number with leading zeros, the zeros are removed. How
can I retain them? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I concatenate text with leading zeros
Dick wrote:
When I concatenate a number with leading zeros, the zeros are removed. How can I retain them? Dick, Try & TEXT(A1,"00000") when concatenating? Beege |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I concatenate text with leading zeros
If the numbers have leading zeros they are already text so should not drop the
zeros. Unless, of course, the numbers are just formatted to show leading zeros. In that case =TEXT(G7,"000000")&TEXT(G8,"000000") Gord Dibben MS Excel MVP On Thu, 31 Jan 2008 09:11:01 -0800, Dick wrote: When I concatenate a number with leading zeros, the zeros are removed. How can I retain them? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TEXT TO COLUMNS WITH LEADING ZEROS | Excel Discussion (Misc queries) | |||
| leading zeros in text format | Excel Discussion (Misc queries) | |||
| Padding a text column with leading zeros | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
| Adding Leading Zeros to Text | Excel Discussion (Misc queries) | |||
Linear Mode
