Previous Topic Next Topic

Number that turns in to date.

Closed
Zet - Feb 6, 2015 at 04:26 AM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - 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 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 252
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