Excel - format a string using formula


Cell A1 = "16092013"

I want A2 to format this string as "16/09/2013".

How can I do this using a formula?

Thank you.
Who is Participating?
andrewssd3Connect With a Mentor Commented:

Open in new window

Should do the job.  I used MID() throughout to make it a bit simpler, but you could also use the LEFT() and RIGHT() formulas for the start and end parts respectively.
KwoofConnect With a Mentor Commented:

...if there are always 8 chars in A1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.