I am trying to concantenate three columns of data that contain numbers.

The first column has 2 numbers, the second has 4, and the third has 2. When
I combine the three nubmers they form a budget group, so all digits are
necessary.

In the second and third column, many have lead zeroes, or even have all zero
digits. When using the Concatenate or & function, it eliminates the leading
zeroes or leaves out a column if it is all zeroes.

Is there a way around this?

Ex: Column 1: 14 Column2: 0098 Column 3: 15
Currently: =A1&B1&C1 gives 149815 versus the needed 14009815

Any help is appreciated. Thank you!