I know it can be done - just don't know how!

Embedded into barcodes we use the Julian date system. I need people to
enter the julian date into the spreadsheet and the adjacent cell to
display the date.

Excel seems to give every possible way to convert to Julian dates but
not the other way round

Can anyone please help this numpty?

Thanks

Tony


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=478831