| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date Value Funtion in Excel 2003 returns an error, but not in Exce
I have a Date Value funtion that returns a #Value error. The strange thing
is that with this same file it does not happen in Excel 2002. The values come through in this version. I have service pack 1 installed for Office 2003, as it did have several fixes for other Date function problems, but this one still persists. Has anyone had this problem yet? |
|
#2
|
|||
|
|||
|
is it possible that you have tools / options / calculation - 1904 date
system ticked? if not could you copy & paste an example of the datevalue function you're having a problem with? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "olearyd" wrote in message ... I have a Date Value funtion that returns a #Value error. The strange thing is that with this same file it does not happen in Excel 2002. The values come through in this version. I have service pack 1 installed for Office 2003, as it did have several fixes for other Date function problems, but this one still persists. Has anyone had this problem yet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
| Excel 2003 Help Runtime Error | Excel Discussion (Misc queries) | |||
| Excel 2003 is changing my date formats | Excel Worksheet Functions | |||
| In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
Linear Mode
