| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Answer to 2/29 gets converted to 2/1
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 | |||
| Answer to 2/29 gets converted to 2/1 | Excel Discussion (Misc queries) | |||
| how do i use 'if' command to display answer in different cell? | Excel Discussion (Misc queries) | |||
| Locking cells after one answer | Excel Worksheet Functions | |||
| i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
| coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Hybrid Mode
