Date field conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I manage a large remote database that contains birthdays in a mm/yy/yyyy format when I download the file

I want to convert these date fields to a format that has only the month and day (mm/dd) in the cell. Is there a function or other wizard that will accomplish this task??
 
Hi
if these are real dates you can simply apply a custom format: goto
'Cells - fomat' and enter the custom format
MM/DD

If this does not help your dates are probably stored as text. Try the
following prior to the above
- format the cell range with the format mm/dd/yyyy
- select an empty cell and copy this cell
- select your range with dates
- goto 'Edit - Paste Sepcial' and choose the action 'Add'

Now apply the steps from above
 
Back
Top