How to convert date

[Salamullah]

Hi,

I am downloading data from JDE in excel and dates are appearing like as follows, how to change them to normal DD/MM/YYYY ?

118362
119002
119246
119273
119316[TABLE="width: 68"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[footoo]

http://www.nimishprabhu.com/tools/jde-julian-date-converter-online.html

 

[Phuoc]

Or try:

=DATE(1900+INT(A1/1000),1,MOD(A1,1000))

 

[Salamullah]

Thanks Footoo & Phuoc both formulas are working