Thread: Date FORMAT problem
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Phaedrus Phaedrus is offline
external usenet poster
  
Posts: 7
Default Date FORMAT problem
Finally, I made it work...

use this
Range("sheetname1!A1").value = "'" & range("sheetname2!A1).value

i.e. a single quote between two double-quote marks prefixed to the
value

this will surely work...
Chill!
Phaedrus

Reply With QuoteReply With Quote