Glad you have a solution but that formula doesn't add an extra space for me
if I enter 1.34.36.12 into A1 manually. Are you importing the data from
somewhere?, if so it may have a leading zero. An alternative formula would
be
=0&TRIM(SUBSTITUTE(A1,".",""))
Regards,
Alan.
"AFSSkier" wrote in message
...
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