Search : in
By :

Date change with column paste

Last answer on Jul 1, 2009 2:24:00 pm BST shhhhane, on Aug 30, 2008 3:02:45 am BST 
 Report this message to moderators

Hello,


Whenever I try to paste the dates and times from one spreadsheet to another, the dates changes from 2008 to 2004. Why won't the dates just hold when I copy and paste from one doc to another. I have excel 2004 for Mac.

Thanks,

-Shane

Configuration: Mac OS X
Safari 525.22

Best answers for « Date change with column paste » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Transforming columns into lines ShowTransforming columns into lines Example Limitations It is endemic for most Linux tools to work with lines, but not with columns (sed, awk, grep, etc..). However, it may happens,that you have a file where the data should be read in...
Change the date of birth on Facebook ShowChange the date of birth on Facebook Changing the date of birth is something that is not possible directly from the "General information" tab from Facebook account. The is one alternative though, click here Enter the email address...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Data compression ShowWhy compress data? Nowadays, the computing power of processors increases more quickly than storage capacities, and is much faster than network band-widths, because this requires enormous changes in the telecommunication infrastructures. Thus, to...
Ask your question Reply

1

andrewsbkk007, on Aug 30, 2008 1:59:29 pm BST
  • +2

Have you checked if your system time is properly set ?

it may be due to this and set it to the real date

   
Reply to andrewsbkk007

2

peggyM, on Sep 22, 2008 10:44:16 pm BST
  • +10

Seems that Excel for Mac uses a 1904 date system to calculate dates. Don't ask me why this is different, but you can change this for each file in the Preferences/Calculation pane. Simply uncheck the "1904 date system" setting.

   
Reply to peggyM

3

Helpedme, on Sep 26, 2008 2:58:00 pm BST
  • +17

I had the same issue, and this fixed it. Any idea how to make this a global change, since it seems that I can only change the active workbook preference and I will have this same issue on a continual basis.

   
Reply to Helpedme

4

 ango, on Jul 1, 2009 2:24:00 pm BST
  • +3

Thanks so much, this WORKS!

   
Reply to ango
Ask your question Reply
They need your help