View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LynnMinn LynnMinn is offline
external usenet poster
 
Posts: 1
Default Converting a date to a text field w/o converting it to a julian da

In order to import data from an Excel spreadsheet into the software I operate
at work all cells need to be formated as text. I recieve numerous
spreadsheets with the date formated as a date XX/XX/XXXX and I need to
convert it to text XXXXXXXX. How can this be done without converting the
number to a julian date?