Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
when i enter 3/15/2005, excel displays 1/1/1904
and the cell contains =3/15/2005 how can i make this work so that it shows my real date, which is 3/15/2005 thanks a lot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Cell date format doesnt change | Excel Worksheet Functions | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
Customized Date Format | Excel Worksheet Functions | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) |