Hello all.
I have a 16 digit account number that I want to add dashes to.
CardWithDashes: Left([CardNumber],4) & '-' & Mid([CardNumber],4,4) & '-' & Mid([CardNumber],8,4) & '-' & Right([CardNumber],4)
It works fine except the third set of numbers seems to replace numbers with zeros.
So: 1234120000020555
Ends Up Being: 1234-1200-0000-0555
What am I missing? Thanks for your help.
I have a 16 digit account number that I want to add dashes to.
CardWithDashes: Left([CardNumber],4) & '-' & Mid([CardNumber],4,4) & '-' & Mid([CardNumber],8,4) & '-' & Right([CardNumber],4)
It works fine except the third set of numbers seems to replace numbers with zeros.
So: 1234120000020555
Ends Up Being: 1234-1200-0000-0555
What am I missing? Thanks for your help.