Concatenating and Keeping an Input Mask

[MrT82]

Hi All,

I have a spreadsheet where I have the following cells:

FD 05 00181

I have used an input mask in order that the 05 column is always two digits long and the 00181 column is always five digits long.

When I concatenate the cells, I end up with FD/5/181… does anyone know how I can make it in order that the concatenated cell is FD/05/00181.

Thanks,

Paul

 

[Joe4]

Custom formatting only changes the appearance of cells, not what is actually contained in them.

You can use the TEXT command to do what you want, i.e. if your values are in cells A1, B1, and C1, try:

=A1 & "/" & TEXT(B1,"00") & "/" & TEXT(C1,"00000")