Text format 1.34.36.12 to look like 01343612
 

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

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

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

Text format 1.34.36.12 to look like 01343612
 

=TEXT(SUBSTITUTE(A1,".",""),REPT("0",8))



AFSSkier wrote:

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

--

Dave Peterson

Text format 1.34.36.12 to look like 01343612
 

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

Text format 1.34.36.12 to look like 01343612
 

Thanks, Kevin


"Dave Peterson" wrote:

=TEXT(SUBSTITUTE(A1,".",""),REPT("0",8))



AFSSkier wrote:

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

--

Dave Peterson