Thread: on excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student
 
Posts: n/a
Default on excel

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
--
Gary''s Student


"molly d" wrote:

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?