| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format
See your other thread. I assume that since that other message you have
changed your settings from the 1900 to the 1904 date system? -- David Biddulph "andresg1975" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format
THANKS
"David Biddulph" wrote: See your other thread. I assume that since that other message you have changed your settings from the 1900 to the 1904 date system? -- David Biddulph "andresg1975" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
