Thread: convert text to dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ben Ben is offline
external usenet poster
  
Posts: 509
Default convert text to dates
Want to convert text date "30 AUG 2006" to a date. Have used "=DATEVALUE()"
but comes back with #value!.
Would greatly appreciate help here.



Reply With QuoteReply With Quote