GMunchel
Active Member
RE: Converting JDE Julian Dates into something more readable .
Yo Nigel, thanks for the Excel macro code converting JDE Julian dates to
Excel date numbers. It works great! A small tip related to your macro is
to copy this code just once into a new module in the ever present VBAProject
(Personal.xls). Then the code is available to every spreadsheet used on
this computer by simply entering the following in any cell
"=PERSONAL.XLS!ConvertJulian(A1)" without the quotes and where A1 can be any
cell reference on the spreadsheet.
World 7.3, Cum 10
Moving to XE, AS/400, Coexistence, HTML
Yo Nigel, thanks for the Excel macro code converting JDE Julian dates to
Excel date numbers. It works great! A small tip related to your macro is
to copy this code just once into a new module in the ever present VBAProject
(Personal.xls). Then the code is available to every spreadsheet used on
this computer by simply entering the following in any cell
"=PERSONAL.XLS!ConvertJulian(A1)" without the quotes and where A1 can be any
cell reference on the spreadsheet.
World 7.3, Cum 10
Moving to XE, AS/400, Coexistence, HTML
