| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Bug in DATEVALUE command in Excel 2002??
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?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Threaded Mode
