Thread: Converting a date to a text field w/o converting it to a julian da
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default Converting a date to a text field w/o converting it to a julian da
Just use the Text function as is:

=text(a1,"yyyymmdd")

Regards,
Fred.

"LynnMinn" wrote in message
...
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?

Reply With QuoteReply With Quote