View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
char needs text char needs text is offline
external usenet poster
 
Posts: 1
Default Convert Date to Text

Is there an easy was to convert date field to text without it converting to a
serial number. Right now I take the date field, convert text to column, add
the two columns with a / then concatenate the five columns, then copy paste
special with values only.

Seems like a long process for simple text. Any suggestions?