Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#VALUE Error
Hi All,
I have a speadsheet model that work fine on three machines, but refuses to work on the forth. All 4 machines have Excel 2003 installed on them. The formula that appears to be breaking it is: =DATE(C2,B2,A2)+TEXT(F2,"hh:mm:ss") This returns #VALUE! Cells A2, B2 and C2 contain the formulas: =DAY(F2) =MONTH (F2) =YEAR(F2) but they all also return #VALUE! Like I said this works fine on three machines just not on the forth? Any ideas? TIA Matthew |
#2
|
|||
|
|||
Hi
what value do you have in F2 and are you sure it is a real date/time value? "Matthew" wrote: Hi All, I have a speadsheet model that work fine on three machines, but refuses to work on the forth. All 4 machines have Excel 2003 installed on them. The formula that appears to be breaking it is: =DATE(C2,B2,A2)+TEXT(F2,"hh:mm:ss") This returns #VALUE! Cells A2, B2 and C2 contain the formulas: =DAY(F2) =MONTH (F2) =YEAR(F2) but they all also return #VALUE! Like I said this works fine on three machines just not on the forth? Any ideas? TIA Matthew |
#3
|
|||
|
|||
Maybe different Regional Options? See Control Panel Regional Options
Time. HTH, Jouni "Matthew" wrote in message ... Hi All, I have a speadsheet model that work fine on three machines, but refuses to work on the forth. All 4 machines have Excel 2003 installed on them. The formula that appears to be breaking it is: =DATE(C2,B2,A2)+TEXT(F2,"hh:mm:ss") This returns #VALUE! Cells A2, B2 and C2 contain the formulas: =DAY(F2) =MONTH (F2) =YEAR(F2) but they all also return #VALUE! Like I said this works fine on three machines just not on the forth? Any ideas? TIA Matthew |
#4
|
|||
|
|||
That is it!
Thanks, checked regional options (thought I had checked that already) and shanged the way a date is displayed and all fine now. Cheers Matthew -----Original Message----- Maybe different Regional Options? See Control Panel Regional Options Time. HTH, Jouni "Matthew" wrote in message ... Hi All, I have a speadsheet model that work fine on three machines, but refuses to work on the forth. All 4 machines have Excel 2003 installed on them. The formula that appears to be breaking it is: =DATE(C2,B2,A2)+TEXT(F2,"hh:mm:ss") This returns #VALUE! Cells A2, B2 and C2 contain the formulas: =DAY(F2) =MONTH (F2) =YEAR(F2) but they all also return #VALUE! Like I said this works fine on three machines just not on the forth? Any ideas? TIA Matthew . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Findlink Error | Links and Linking in Excel | |||
Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
Downloading Templates for Excel error with a windows error. | Excel Discussion (Misc queries) | |||
Error message with embedded objects. | Setting up and Configuration of Excel | |||
#REF error | Excel Worksheet Functions |