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
 
Top