Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I know this seems like an easy one, but I am working on a research project for the Director of the program that I work for and I need to change the way birthdate is formatted in a particular column. It reads year first and then month and day.. 20051024 and he wants it to read 10/24/2005. I assumed I could just go to formatting and change it and it will not let me. There are 6900 some odd records so there is no possible way to do them manually.. Can anyone help? -- stittalPosted from - http://www.officehelp.in |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
format date in excel | Excel Discussion (Misc queries) | |||
Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Format Cells - Date options | Excel Discussion (Misc queries) |