Leading zero's and concatenate with text field   

How can keep the leading zeros in my field when I concatenate a text field 
with a numeric field.

Example =concatenate(A1, B1)

Column A1     B1        C1    
         
            A     00001    A00001

When I concatenate a1 with b1, the current result is A1 and not A0001.

I need to keep the leading zeros from B1.

thank you

date: Mon, 9 Jun 2008 07:03:00 -0700   author:   TommyD_49

Re: Leading zero's and concatenate with text field   

"TommyD_49"  wrote in message 
news:A3B18D12-FCF6-4450-B49E-2BB4E55D6A36@microsoft.com...
> How can keep the leading zeros in my field when I concatenate a text field
> with a numeric field.
>
> Example =concatenate(A1, B1)
>
> Column A1     B1        C1
>
>            A     00001    A00001
>
> When I concatenate a1 with b1, the current result is A1 and not A0001.
>
> I need to keep the leading zeros from B1.
>
> thank you


Short, general answer: convert the numeric field to text (string) before 
concatenating.
For better answers, provide information. What software product(s) are you 
using? What technologies? Techniques for achieving your goal will vary 
widely depending on answers to the above.

date: Tue, 10 Jun 2008 16:15:36 -0500   author:   PvdG42