Thread
:
DATEVALUE gives #VALUE! error
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
hmm
external usenet poster
Posts: 175
DATEVALUE gives #VALUE! error
I have in cell A25 the text "- 6/19/2007 6:22:12 PM". The formula
=DATEVALUE((TRIM(MID(A25,FIND("-",A25)+3,11))))
is giving me a #VALUE! error.
How can I get it to return the correct date?
Reply With Quote
hmm
View Public Profile
Find all posts by hmm