Dates in Excel are formatting as numbers rather than as dates

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Symptoms

The following are examples of error messages that may occur:  

  • Dates showing as numbers in Excel

 

Causes

Cells containing dates are incorrectly formatted as number fields.

Resolution

Date values in Excel can be formatted as numbers. If this is occurring select the relevant cells and re-format them as Dates.  

Applies To

  • Excel