on excel

M

molly d

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?
 
G

Gary''s Student

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
 
M

molly d

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top