Thank your Max, you explained so even I got it to work! Thank YOU!
--
Ron


"Max" wrote:

Just some implementation assist ..

Assume data is in A1:A5000,

Put in B1 (Fred's formula):
=DATE(INT(A1/1000),1,MOD(A1,1000))

Format B1 as Custom, Type: d-mmm-yy

Copy B1 down to B5000
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Ron" wrote in message
...
Thank you Fred, sorry, but I don't understand, is it possible to expand
you
explantion some. If I have 5000 Julian dates in column A how would I use
your
formula?
Thanks
--
Ron