changing a cell from date to a number
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? |
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? |
All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com