Previous Topic Next Topic

Number that turns in to date.

Closed
Zet - Feb 6, 2015 at 04:26 AM
vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
 - Feb 6, 2015 at 05:33 AM
Hello,

hi

I'm Nokuthula. I want to ask why when I try to put a number it turn and become a date. Why is that ?

1 reply

Answer 1 / 1
vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
 249
Feb 6, 2015 at 05:33 AM
Hello Nokuthula,

I would say that the cell (perhaps the whole column) is formatted as Date.

Highlight the cell (or whole column) and right click. Select "Format Cells"--->select "General" or "Number"--->click OK.

This should solve the issue for you.

Regards,
vcoolio.
0