Thread: How do I create list validation from code without the text being converted into date format?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
  
Posts: 1
Default How do I create list validation from code without the text being converted into date format?

Don't know if this will be what you want, but we can force a cell to
become text by putting an apostrophe in front. This becomes invisible
in the cell.
eg.
'- put an apostrophe to force cell to text
Range("A1").Value = "'" & "5-7"


--
BrianB


------------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...info&userid=55
View this thread: http://www.excelforum.com/showthread...hreadid=487878

Reply With QuoteReply With Quote