Value function not working as expected in Excel 2007

B

bdevier

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
 
D

David Biddulph

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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: =DSUM not working as expected 4
type mismatch error in macro in excel 0
=Large function returns #NUM! 5
Help with conditional formatting in Excel 2010 8
#value! error in sum function 8
RTD problems in Excel 2003 2
Median If in Excel not working 4
Lottery 6

Top