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)

Practiceguys wrote:

How do I insert a character into a string at a specified position.

ie; 19120725 needs to be 1912/07/25....

Thanks,

--

Dave Peterson