Value function not working as expected in Excel 2007
 

I have a speadsheet that uses the RTD function to bring data into the
spreadsheet. This data comes in as TEXT. I verified this T(value) function.
However, I get #Value! error when I use Value(text) to convert the data to a
numeric value. This only occurs in Excel 2007. In Excel 2003 it works
correctly.

Example:
A1 = RTD(ProgID, Server, Topic1, Topic2) = 11-28-2008 02:46:49
A2 = TYPE(A1) = 2 (text=2)
A3 = Value (A1) = #Value!

Any help is appreciated

Value function not working as expected in Excel 2007
 

Are you sure that your Windows Regional Options are set to suit the date
format you are using? Perhaps it is expecting D-M-Y, not M-D-Y ?
--
David Biddulph

"bdevier" wrote in message
...
I have a speadsheet that uses the RTD function to bring data into the
spreadsheet. This data comes in as TEXT. I verified this T(value)
function.
However, I get #Value! error when I use Value(text) to convert the data to
a
numeric value. This only occurs in Excel 2007. In Excel 2003 it works
correctly.

Example:
A1 = RTD(ProgID, Server, Topic1, Topic2) = 11-28-2008 02:46:49
A2 = TYPE(A1) = 2 (text=2)
A3 = Value (A1) = #Value!

Any help is appreciated