Forum Discussion
Phil_Tizzard
Jan 04, 2024Copper Contributor
Error message in Excel
I have two sheets in a book that are essentially identical. In each, the first row contains a series of dates in the (custom) format dd/mm. Below each date is a column of numbers and at the bottom of...
- Jan 04, 2024
Weird. I'd simply ignore the warning, or disable it in File > Options > Formulas > Error checking rules.
HansVogelaar
Jan 04, 2024MVP
Dates are stored as numbers in Excel.
Has the range been formatted as a table on one of the sheets, but not on the other?
Phil_Tizzard
Jan 04, 2024Copper Contributor
No it hasn't.
- HansVogelaarJan 04, 2024MVP
Weird. I'd simply ignore the warning, or disable it in File > Options > Formulas > Error checking rules.
- Phil_TizzardJan 04, 2024Copper Contributor
OK thanks.