Concatenate

[Mike G]

I want to join two columns of data into one. The first
column has this data: 18000. The second column has data
similar to this but of varying values like this: 00566. I
want the product to appear like this: 1800000566 but I get
18000566 because it lops off the two leading zeros. How
can I get around this?

 

[Dave R.]

Look for a message by Meaux called "leading zeros" which has solution(s) in
it. It's from 11/5/03.

 

[Gord Dibben]

The entire thread of which can be seen here.

http://snurl.com/2v9n

Gord Dibben XL2002