Hi all
Probably a simple answer to this one. I have 3 cells of data which I want to concatenate. However one of the cells is in a custom format which is padding out any values in it with leading zeroes to make it 12 characters in length. E.g:
567.78 becomes 000000567.78
3.20 becomes 000000003.20
etc etc
When this cell is concatenated it loses it's leading zero formatting. I've tried everything I can think of but short of actually typing the numbers manually using an ' at the beginning, I'm stumped!
Cheers
Mark
Probably a simple answer to this one. I have 3 cells of data which I want to concatenate. However one of the cells is in a custom format which is padding out any values in it with leading zeroes to make it 12 characters in length. E.g:
567.78 becomes 000000567.78
3.20 becomes 000000003.20
etc etc
When this cell is concatenated it loses it's leading zero formatting. I've tried everything I can think of but short of actually typing the numbers manually using an ' at the beginning, I'm stumped!
Cheers
Mark