| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates vary in a copied sheet
emailed a file and dates on sheet they see are exactly 1 day and 4 years
earlier than actual dates shown on my sheet. -- JeannieC |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dates vary in a copied sheet
Jeannie
Sounds like you are on the 1904 date system. This can be changed by either you or the recipient of your workbook at (pre 2007) Toolsoptionscalculation tab & change the setting for th 1904 date system. This change will affect otgher workbooks, so be careful. Mike Rogers "Jeannie" wrote: emailed a file and dates on sheet they see are exactly 1 day and 4 years earlier than actual dates shown on my sheet. -- JeannieC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The Dates change when sheet copied to a new workbook | Excel Discussion (Misc queries) | |||
| Vary sheet name & sum across multiple sheets | Excel Worksheet Functions | |||
| EXCEL macro that will vary when copied | Excel Worksheet Functions | |||
| Copied dates automatically change to previous day | About this forum | |||
| one sheet to another, when teh lines vary | Excel Worksheet Functions | |||
Linear Mode
