Dates in Excel are formatting as numbers rather than as dates

From Sage Intelligence Knowledgebase
Jump to: navigation, search


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.  

Applies To

  • Excel