Thread: Convert date format 2-Jan-97 to text 02Jan97
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Convert date format 2-Jan-97 to text 02Jan97
can you just change the format to ddmmmyy

--
Don Guillett
SalesAid Software

"SteveC" wrote in message
...
Hi, any clue how I an transform a column of dates into a text format like
this:

2-Jan-97 to text 02Jan97

thanks...



Reply With QuoteReply With Quote