Text format 1.34.36.12 to look like 01343612
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
|