View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

What number did you enter?

If you entered just digits (or digits and a decimal point), change the
format of the cell to General or a Number format.

If you entered the number as a fraction, e.g., 1/3, XL's parser will
always try to interpret that as a date. To enter this type of fraction,
include the 0, e.g.,:

0 1/3

In article ,
mwhite wrote:

I entered a number in a cell. When I went to the next cell, the number i
just entered changed to a date. What do I need to do to keep the number
there and not have the date keep showing up?