Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing the formatting of birthdates
Click on Format Cell--custom--and type dd/mm/yyyy.
Hope it will help you. "Donna" wrote: I have an Excel file with the birthdate field formatted as yyyymmdd and I need to export it as a .csv file with the date formatted as mm/dd/yyyy (the change in order and the slashes are critical). I know how to save as a .csv file, but I cannot figure out how to change the date formatting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing the formatting of birthdates | Excel Discussion (Misc queries) | |||
How do I sort two columns without changing the formatting? | Excel Worksheet Functions | |||
I want to sort by month, date, year. Birthdates. How do I do it | Excel Worksheet Functions | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions | |||
Calculating Ages from Birthdates | Excel Discussion (Misc queries) |