Dates in Excel are formatting as numbers rather than as dates
The following are examples of error messages that may occur:
- Dates showing as numbers in Excel
Cells containing dates are incorrectly formatted as number fields.
Date values in Excel can be formatted as numbers. If this is occurring select the relevant cells and re-format them as Dates.