P
Practiceguys
How do I insert a character into a string at a specified position.
ie; 19120725 needs to be 1912/07/25....
Thanks,
ie; 19120725 needs to be 1912/07/25....
Thanks,
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
=LEFT(A2,4)&"/"&MID(A2,5,2)&"/"&RIGHT(A2,2) or
=TEXT(A2,"0000\/00\/00")
=TEXT(A2,"0000\/00\/00")
J
JP
You would need a combination of LEFT, MID and RIGHT functions to do
this.
If your data was in A1, try this:
=LEFT(A1,4)&"/"&MID(A1,5,2)&"/"&RIGHT(A1,2)
HTH,
JP
this.
If your data was in A1, try this:
=LEFT(A1,4)&"/"&MID(A1,5,2)&"/"&RIGHT(A1,2)
HTH,
JP
C
CLR
One way.........
=LEFT(A1,4)&"/"&MID(A1,5,2)&"/"&RIGHT(A1,2)
Vaya con Dios,
Chuck, CABGx3
=LEFT(A1,4)&"/"&MID(A1,5,2)&"/"&RIGHT(A1,2)
Vaya con Dios,
Chuck, CABGx3
D
Dave Peterson
I'd convert the value to a real date and then format that cell the way I want.
Then I could use that real date in other calculations.
=--(TEXT(A1,"0000\/00\/00"))
(and with a custom format of yyyy/mm/dd)
Then I could use that real date in other calculations.
=--(TEXT(A1,"0000\/00\/00"))
(and with a custom format of yyyy/mm/dd)