can someone tell me how i can change this julian date output to be in this format instead..here is the formula i use the output it gives and the order i would prefer….
=TEXT(C5,”yy”)&TEXT((C5-DATEVALUE(“1/1/”&TEXT(C5,”yy”))+1),”000″) gives output Ex: 02058 would prefer it to give 0582…we do not use 02 for year we use 2 and we do not want year first we want it last…any suggestions?
thanks