Need help changing date format in Excel

[funkmeister79]

Hello:

Currently, the date format is a number (for example, 20121117). However, I would like to change it to 11/17/2012. I tried using the date format options in Excel, and the cell ends up with "##########"

Thank you!

[Ace_XL]

Try in a separate cell..

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

[dogberry]

Hi

If the above does not work have you tried splitting it with the text to columns and working on it from that perspective.

Chris

[funkmeister79]

The first suggestion worked - thank you very much!