Thread: How do I convert dd/mm/yy date format to yyddd Julian date format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brad Autry Brad Autry is offline
external usenet poster
  
Posts: 34
Default How do I convert dd/mm/yy date format to yyddd Julian date format
Format cells Custom and in "Type" enter: yyyy dd mm or whatever you'd like

"itzy bitzy" wrote:

I have done this before, but can't remember how!
Reply With QuoteReply With Quote