View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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??