How to Prevent Julian Dates in Excel 2003

1. Click on the cell with the Julian date.
2. Type '=RIGHT(YEAR(A1' into the 'Find what?' text box.
3. Search for the Excel formula that converts standard dates to Julian dates. The full formula is '=RIGHT(YEAR(A1),2)TEXT(A1-DATE(YEAR(A1),1,0),'000')' where 'A1' is the cell location of the Julian date.
4. Click on the cell with the formula, then press the 'Delete' key to remove the formula.