I'm updating an old spreadsheet so dates are now being pulled from another sheet within the same book. Previously the date was entered by hand in two places. The linked date is not accepting the cell format of Mmm-yy. Since this is pulled into a chart, it has to be in the correct format or the chart is messed up. Any ideas why this is causing trouble?