Date field conversion
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
--
Regards
Frank Kabel
Frankfurt, Germany
EdFast wrote:
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??
|