N
noobie6675
Hi,
I have a number of fields that i need to concatenate into one.
This process is easy enough althouh i have ran into a major problem..
some of the fields are in the form of 00045 and to get this i simply
formatted it as a Custom 00000.
Now when i concatenate this it doesnt bring over the 0's it only brings
over the "45".
Anyone know how i can do this otherway? or get the 0's in front of the
number such that concatenate will work?
cheers
I have a number of fields that i need to concatenate into one.
This process is easy enough althouh i have ran into a major problem..
some of the fields are in the form of 00045 and to get this i simply
formatted it as a Custom 00000.
Now when i concatenate this it doesnt bring over the 0's it only brings
over the "45".
Anyone know how i can do this otherway? or get the 0's in front of the
number such that concatenate will work?
cheers