Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Date change with column paste

shhhhane, on Saturday August 30, 2008 03:02:45 AM
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
Reply to shhhhane  Report this message to moderators Go to last message

1


  • 1    This message seems useful, vote!
  • Ce message ne vous semble pas utile, votez !
  • Report this message to moderators
andrewsbkk007, on Saturday August 30, 2008 01:59:29 PM
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


  • This message seems useful, vote!
  • Report this message to moderators
peggyM, on Monday September 22, 2008 10:44:16 PM
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


  • This message seems useful, vote!
  • Report this message to moderators
 Helpedme, on Friday September 26, 2008 02:58:00 PM
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
Ask your question Reply

Results for

Need help with simple Macro (Solved) Hello, I have an Excel worksheet with data in columns that I would like to move to rows. The data is in A1:AN1 - I would like to make it shwo in the worksheet in rows A1 thru A40. Do you have a macro that will do this? Thanks! en.kioskea.net/forum/affich-26033-need-help-with-simple-macro
Search engine macro Hello, On sheet4 i have lots of data in columns. And i'm interested in two of them: col. i and col. k. In column i i have code (12-13 char). And in column k i have count numbers. I need macro, that takes the code from sheet4(column i), searches... en.kioskea.net/forum/affich-27471-search-engine-macro
If then statement, based on status Hello, I'm trying to find out how to do this in exel. I'm not sure if it's a macro. If entry on Column B is not "Done," and the date on Column K is equal or before Today's Date, then make the background color of that cell in Column... en.kioskea.net/forum/affich-32126-if-then-statement-based-on-status

Results for

Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel 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... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell
How to change or recover your Windows Live Messenger passwordHow to change or recover your Windows Live Messenger password 1.Changing your password (Windows Live Messenger) 2. Password Recovery Secret question Send password reset instructions to your alternative email address Download MSN Messenger... en.kioskea.net/faq/sujet-155-how-to-change-or-recover-your-windows-live-messenger-password
1 2 3 Next

Results for

Changin format of date in excelHello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/mm/yy. How can I do that, pls help. eg - I need to convert "sat Jun 29 00:00:00 PST 1996" to "29/06/96".... en.kioskea.net/forum/affich-28689-changin-format-of-date-in-excel
Change Date Format in XPHello, The system default short date format is: dd-MM-yyyy. We have an application that runs with the date format in: dd/MM/yyyy. Is there any method (e.g. batch) so that we can change the date format temporary when launch the application and then... en.kioskea.net/forum/affich-5052-change-date-format-in-xp
Date format in excel.Hello again, Is there a way to make excel read fields left padded with a 0. For example I have a program that only reads date format like this yymmdd, so when I open the csv file in excel it reads 080725 as 80725 instead. Then when I save any changes... en.kioskea.net/forum/affich-16756-date-format-in-excel
1 2 3 Next

Results for

Download Earth AlertsWith the total climatic changes which they meet in the world, it is necessary to put on up to date on different climatic phenomena. Earth Alerts is an application which provides the most recent with information on events natural in the United States.... en.kioskea.net/telecharger/telecharger-765-earth-alerts
Download Free PDF to Word ConverterDocuments PDF are certainly most on and the most stable for transfers, since they cannot be changed. However, sometimes they need data contained in a document PDF which they would like to edit or to change. Free PDF to Word Converter is as name... en.kioskea.net/telecharger/telecharger-572-free-pdf-to-word-converter
Download JPGDateChangerWhen you import pictures on your hard disk and that you change the rotation of picture only, Windows change directly the " date of last modification ".Foreigner, this function is useful to be able one of the changes which you performed to it.... en.kioskea.net/telecharger/telecharger-620-jpgdatechanger
1 2 3 Next

Results for

WiMAX promises to transform wireless Internet worldVisitors walk past the WiMAX stand at the 3GSM congress in Barcelona, in February 2007. As US technology giants including Google place a multi-billion dollar bet on WiMAX, backers of the wireless data-streaming format say it will radically change... en.kioskea.net/actualites/wimax-promises-to-transform-wireless-internet-world-10354-actualite.php3
WiMAX promises to transform wireless Internet worldVisitors walk past the WiMAX stand at the 3GSM congress in Barcelona, in February 2007. As US technology giants including Google place a multi-billion dollar bet on WiMAX, backers of the wireless data-streaming format say it will radically change... en.kioskea.net/actualites/wimax-promises-to-transform-wireless-internet-world-10353-actualite.php3
1 2 3 Next

Results for

BIOS optimisation The BIOS (Basic Input/Output System) is a small memory chip located on the motherboard containing data that define the system parameters. As some BIOS data are written in a ROM, it is not possible to change them, however, certain parameters are... en.kioskea.net/repar/optibios.php3
Kioskea - Computing community Encyclopedia / Reviews IT Beginners Office software Computer history IT Windows Process Spreadsheet IT Pro Change management Change management Resistance to change Viral Marketing E-Enterprise CRME-businessERP DatawarehouseIT professions Project... en.kioskea.net/index.php3
Spreadsheets - Worksheets Spreadsheets display data and formulas in a table form (lines and columns) called a worksheet. A worksheet is made of lines (numbered with numbers) and of columns (numbered with letters). The intersection of a line and a column is called a cell. A... en.kioskea.net/tableur/tabfeuille.php3
1 2 3 Next