T
Tim
I have a couple columns of numbers that needed zeros added to them as
follows:
A B C
145 29 812
125 8 4
need to be formatted as
145 29 812
125 08 004
Using format each column using Custom. Format the 2 digit column as 00, and
the 3
digit column as 000 the columns work fine.
But...I then need to use the columns in a combinations formula =A2&B2&C2 to
have a resulting 8 digit number...but the 'custom' 0's do not convert...I
get a number like 12584 instead of the needed 12508004 ?
Anyway around this issue ?
Thanks, Tim
follows:
A B C
145 29 812
125 8 4
need to be formatted as
145 29 812
125 08 004
Using format each column using Custom. Format the 2 digit column as 00, and
the 3
digit column as 000 the columns work fine.
But...I then need to use the columns in a combinations formula =A2&B2&C2 to
have a resulting 8 digit number...but the 'custom' 0's do not convert...I
get a number like 12584 instead of the needed 12508004 ?
Anyway around this issue ?
Thanks, Tim