Thread: How do I convert dd/mm/yy date format to yyddd Julian date format
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default How do I convert dd/mm/yy date format to yyddd Julian date format
Hi,
with custom format, choose the range to be changed, right click on the
mouse, custom, type

yy ddd

"itzy bitzy" wrote:

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