View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seamless Seamless is offline
external usenet poster
 
Posts: 1
Default Convert Date to Text for Export

I need to convert a date format to a text version of that date in order to
export to another application properly. Right now, the date format show
MM/DD/YYYY and is serialized. When I export, the text for that date comes up
with YYYYDDMM which doe not work with the application. If there is a way to
convert the date format so the text would be in order (12/18/2007) that would
be great. Please let me know. Thanks!