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
