When reading in a numeric field from an .XLSB file, I’m seeing that the value 32.38 is giving me the DateTime value of 2/1/1900 9:07:12 AM when inspecting the DateTimeValue property of the Cell. Can you enlighten me on how this value was reached?
Please have a look at the following article which explains conversion of number to date in Excel.
Which part of this article should I be looking at? When I try to use the DATEVALUE function in Excel directly, I get an error of “a value used in the forumula is of the wrong data type”, which makes sense. But, this is not what happens when I use the DateTimeValue.
Nevermind, I see that it is a combination of Date and Time formatting for the cell.
It seems that your issue is resolved. Feel free to write us back if you have any other query in this regard.