Thread: Convert date + time text format to date format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Ho Paul Ho is offline
external usenet poster
  
Posts: 5
Default Convert date + time text format to date format
Hi,
For example. I have a text "5/30/2007 09:30 AM" in cell a1. How can I
convert it to Date format? Thanks.
Reply With QuoteReply With Quote