on excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

While writing a column of numbers, some numbers suddenly change to dates. I
erase the date, rewrite the numbers and, again, pressing enter it changes
back to a date. Does not do it each time, but several numbers in the column
will have dates. I am a new excel user so what am I doing wrong?
 
If you enter the same value into two cells and one cell displays the value
and the other cell displays a date, then the problem is formatting.

Empty the cells, format the cells as general and then re-enter the values
 
Thanks you. I worked.

Gary''s Student said:
If you enter the same value into two cells and one cell displays the value
and the other cell displays a date, then the problem is formatting.

Empty the cells, format the cells as general and then re-enter the values
Click to expand...
 
Back
Top