View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
airedale girl airedale girl is offline
external usenet poster
 
Posts: 1
Default Excel, how do I write a macro to convert the date value to text?

My worksheet contains several thousand records in which I have 3 columns with
date values. I need to know how to write a macro that would add a tick mark
to the beginning of each date to convert it to a text format.