Remove the year from a date
 

I have changed the formatting to mm/dd - but I want to remove the actual date
data from my cell. How can I do that?

Excel stores dates as numbers, not as dates........ie: April 15, 2005 is
stored as 38457. They only appear as dates that we're familiar with when
the cellS they are in are "formatted" as a date...........if you want only
the month and day to show on the display, select the cell Right-click
FormatCells NumberTab Date and select a format in the window to the
right............only the month and day will show, but it will still be a
"date" and will act as such..........

However, if you really want only the two digits for the month and day to
show and have no relationship to a year, then just type an apostrophe in
front of your entry. The apostrophe will not show, but it will turn the
entry into TEXT.........

hth
Vaya con Dios,
Chuck, CABGx3


"newbie" wrote in message
...
I have changed the formatting to mm/dd - but I want to remove the actual
date
data from my cell. How can I do that?