After exporting data from some applications, when open it
using MS Excel, you can see data in date column like 41996.453633. See the
sample in below picture.
This happens because of the problem in format in the cell.
To view real date time in the column do like below.
Right click on the column letter and select “Foramt Cells”.
Now you will see format cells tab window. Select Date > Date type like below
picture.
Now you successfully changed your column date time as a
readable one.
No comments:
Post a Comment