Thread: Date FORMAT problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Phaedrus Phaedrus is offline
external usenet poster
  
Posts: 7
Default Date FORMAT problem
Eric,

try this instead
Range("sheetname1!A1").value =
Application.worksheetfunction.Text(range("sheetnam e2!A1).value,"mm/dd/yyyy")

you can change the 'format' string to macth your need.

Chill!
Phaedrus

Reply With QuoteReply With Quote