| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Answer to 2/29 gets converted to 2/1
enter 0 2/29
the single space after the zero is necessary -- Gary's Student "Barb Reinhardt" wrote: When I enter just 2/29 into a cell in excel, the resulting value is 2/1/2029. I'm wondering if that's what you are seeing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i use 'if' command to display answer in different cell? | Excel Discussion (Misc queries) | |||
| Can Drop Down Boxes jump to the answer as you type? | Excel Discussion (Misc queries) | |||
| i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
| Excel Answer Wizard BROKEN | Excel Discussion (Misc queries) | |||
| coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Hybrid Mode
