Forum Discussion
Convert Integer to Date in Excel issue
Hi,
Currently I have issue regarding converting integer to date in Excel.
If I put 60 in one of the cell, then I convert it to Date it become 29-Feb-1900 which is not correct.
If I put 61, ...
Hi,
The cells in which you entered numbers are formatted as dates!
Just select these cell, go to Home >> Number and then select General Format or Number format.
Or do select these cell and then press (Ctrl+Shift+~) to apply the General Format.