View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via135 via135 is offline
external usenet poster
 
Posts: 94
Default converting text strings into dates

i'm having a1:a10 dates. but when i check it out whether they are real
dates by using datevalue function thru b1:b10 some of them giving
#value errors. how can i convert all of them to real dates?


-via135