Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenation
Hi,
I am trying to concatenate two fields in excel.In this, one field is a custom number field .When I am doing the concatenation I am losing the zeros before the number. Example 00123 + abc in this case I am getting a result of 123abc .But I am looking forward to get 00123abc. Is it possible in excel?Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenation
hi
see your post under worksheet functions. most regulars here dislike double posting. Regards FSt1 "Muthalaly" wrote: Hi, I am trying to concatenate two fields in excel.In this, one field is a custom number field .When I am doing the concatenation I am losing the zeros before the number. Example 00123 + abc in this case I am getting a result of 123abc .But I am looking forward to get 00123abc. Is it possible in excel?Please help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenation
Please do NOT multi-post - you have answers elsewhere.
Pete On Jun 24, 12:24*pm, Muthalaly wrote: Hi, I am trying to concatenate two fields in excel.In this, one field is a custom number field .When I am doing the concatenation I am losing the zeros before the number. Example 00123 + abc in this case I am getting a result of 123abc .But I am looking forward to get 00123abc. Is it possible in excel?Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation | Excel Discussion (Misc queries) | |||
concatenation | Excel Worksheet Functions | |||
Help with Concatenation | Excel Worksheet Functions | |||
Help with Concatenation | Excel Worksheet Functions | |||
concatenation | Excel Discussion (Misc queries) |