DATEVALUE

[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

 

[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

 

[Frank Kabel]

Hi
what is the value in B2. Maybe this is already a date value?