I’m getting data from excel using importexcel module.
the data that im getting back it’s in array.
one of the value that I’m getting supposed to be a date.
When it comes across in the array it’s showing as number! (I guess because the importexcel module is using property cell.value instead of cell.text)
Right now I have a number 42736 I want to turn it into a date it should be 01/01/2017.
you can type this number in excel then press control shift 3 to change it to date format
how do I convert a number into a date?