You may use a formula like this:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
You need to use the formula in a different cell, I don't know any format
sequence that can do what you want in place.

Hope this helps,
Miguel.

"Cathie" wrote:

I have a list of birthdates (ex. 19990901) how do I format this number to
show the birthdate as 1999/09/01 or 01/09/1999. I prefer the latter. Any
help is greatly appreciated.