Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Extract date from cell | Excel Worksheet Functions |