View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
waybomb waybomb is offline
external usenet poster
 
Posts: 10
Default Generating a Julian date, but only showing the last two number

Hi again Joel

Here's the fomula I put in now:
=TEXT(C160,)&TEXT(MOD(C160-DATEVALUE("1/1/"&TEXT(C160,"yy"))+1,100),"000")

What this returns when the reference cell is 6/22/09 is 073. All I want
returned is 73.

How do I drop the zero?

Thanks
Fred