Thread: How to prevent text turning into date format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ylrino ylrino is offline
external usenet poster
  
Posts: 1
Default How to prevent text turning into date format

Hi all, i have been trying write a marco to extract the date portio
from date:time. The problem is the latter(date:time) is in strin
format and when i used the left() function to extract the date, i
automatically converts into date format. How can i prevent this??
Thanks for your help

--
ylrin
-----------------------------------------------------------------------
ylrino's Profile: http://www.excelforum.com/member.php...fo&userid=3488
View this thread: http://www.excelforum.com/showthread.php?threadid=54627

Reply With QuoteReply With Quote