changing a cell from date to a number

M

mwhite

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

JE McGimpsey

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
 

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