Kurganscott
New Member
- Joined
- Nov 10, 2005
- Messages
- 4
I have need to combine 5 columns into one field. Using the CONCATENATE function accomplishes this but in fields that begin with a zero, the formula (or possibly the format of the target cell, although I have tried variations with no success) removes the zeros leaving on the number at the end. The needed final result is a coding field for another program that requires those zeros.
Anybody? Bueller? Thanks!
Anybody? Bueller? Thanks!