hi
does the date appear as 4/10 in the cell? if so then everything is normal.
fomating changes the way the data looks. it does not change the data. what
appears in the formula bar is what is in the cell such as a fomula. the
formula appears in the formula bar and the results appears in the cell. in
your case, the formated version of the date would appear in the cell but the
full date would appear in the formula bar.

Regards
FSt1

"Excelsior731" wrote:

The date in the cell keeps adding the year when I don't want it to, even if I
select "Category - Date" and "Type - 3/14". I need to have ONLY the month and
day (2 digits each in the date format so it's sortable), not the year, but
the year keeps appearing after the date in the formula bar.