I'm trying to convert a column of around 1600 dates into their Date Numbers
using the DATEVALUE command. 99% of the dates have converted correctly, but
some keep returning the #VALUE error. The source cell properties of correctly
converted and errors ones are identical. When using the 'Show Calcuation
Steps' option the converted value is shown in the cell i.e.
"DATEVALUE(37966)" but the dialog box states that the next evaluation will
result in an error.

Any thoughts??