DATEVALUE

D

Dana

Has anyone had a problem with the DATEVALUE function in
Excel 97? I can get it to work with a text date in it,
but not with a cell reference.
For example:
=DATEVALUE("3-Nov-04")
works, but
=DATEVALUE(B2)
does not.

Does anyone have any suggestions?

Thanks in advance,
Dana
 
T

Trevor Shuttleworth

Dana

I think it depends on what is in cell B2. Try: '03/11/2004 The single
quote means it is treated as a string but displays as 03/11/2004

Regards

Trevor
 

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

Formula with DateValue and doing Fill doesn't work, need help 2
Using multiple IF statements 1
Looking up a date 3
datevalue() 6
DATEVALUE QUESTION 4
Help With DATEVALUE 3
DATEVALUE OF CURRENT DATE 5
Nesting the ROW() command into a Conditional Format Formula 4

Top