Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |