| Subject: Leading zero's and concatenate with text field |
| Group: microsoft.public.msdn.general |
| Date: 6/9/2008 7:03:00 AM |
| From: =?Utf-8?B?VG9tbXlEXzQ5?= [Email Address Protection] |
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 |
| Back |
| Subject: Re: Leading zero's and concatenate with text field |
| Group: microsoft.public.msdn.general |
| Date: 6/10/2008 2:15:36 PM |
| From: "PvdG42" [Email Address Protection] |
"TommyD_49" <TommyD_49@discussions.microsoft.com> 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. |
| Back |