Thread: How do I convert dd/mm/yy date format to yyddd Julian date format
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How do I convert dd/mm/yy date format to yyddd Julian date format
But that doesn't give a Julian date, Eduardo.
Today it would give 09Thu, instead of 09344
--
David Biddulph

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