Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |