Text format 1.34.36.12 to look like 01343612
Your formula =0&SUBSTITUTE(A1,".","") added an extra space, 0 1343612
However, =TEXT(SUBSTITUTE(A1,".",""),"00000000") does work, 01343612.
--
Thanks for the tip, Kevin
"Alan" wrote:
Not sure about a format, but the formula
=0&SUBSTITUTE(A1,".","")
will do it, copy and Paste Special Values to lose the formula,
Regards,
Alan.
"AFSSkier" wrote in message
...
Does any on know how to format 1.34.36.12 to look like 01343612
I tried: Text([source],"00000000") in excel with no resolute.
--
Thanks, Kevin
|