Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formatting
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formatting
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formatting
=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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formatting
Cathie
Without formulas. DataText to ColumnsNextNextColumn Data FormatDateYDM and finish. Gord Dibben MS Excel MVP On Wed, 2 Aug 2006 11:45:03 -0700, 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Formatting Custom Number | Excel Discussion (Misc queries) | |||
Text Function with Different Formatting for Number | Excel Discussion (Misc queries) | |||
concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) |