Concatenation

's Computer Specifications

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.

's Computer Specifications

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.
>

's Computer Specifications

Please do NOT multi-post - you have answers elsewhere.

Pete

On Jun 24, 12:24*pm, Muthalaly <Muthal...@discussions.microsoft.com>
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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenation	krymer	Microsoft Access Queries	1	18th Oct 2008 05:32 AM
Concatenation	krymer	Microsoft Access Queries	0	18th Oct 2008 05:11 AM
Concatenation	MichaelS	Microsoft Excel Misc	8	11th Sep 2008 07:54 AM
Concatenation	=?Utf-8?B?VG9tbWll?=	Microsoft Access	1	25th Oct 2004 08:17 PM
Concatenation	Ray	Microsoft Access Queries	5	17th Dec 2003 05:49 PM