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.
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.
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.
=TEXT(DATE(LEFT(A1,4),RIGHT(A1,2),MID(A1,5,2)),"mm/dd/yyyy")
Vaya con Dios,
Chuck, CABGx3
"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.
Cathie
Without formulas.
Data>Text to Columns>Next>Next>Column Data Format>Date>YDM and finish.
Gord Dibben MS Excel MVP
On Wed, 2 Aug 2006 11:45:03 -0700, Cathie <[email protected]>
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks