Thread: Date to Text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
booshi booshi is offline
external usenet poster
 
Posts: 7
Default Date to Text

Please advise how to copy a column of the following date format as text
into another column.

Selection.NumberFormatLocal = "yyyy-mm"

eg Instead of 2003-0,1 4-Jan-2003 returns to 37625