Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Finalizing" format change to text | Excel Discussion (Misc queries) | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Format Number to Text | Excel Worksheet Functions |