New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Switcher Hangout The place for switchers to discuss their new machines, and how to work with OS X. General support can be had here for newbie stuff, like "How do I restart my new iMac?" :)

Help with excel sheet copy question please


Post Reply New Thread Subscribe

 
Thread Tools
bmackstuff

 
Member Since: Jan 14, 2010
Posts: 1
bmackstuff is on a distinguished road

bmackstuff is offline
Recent convert here.

When I am need to copy a excel sheet to a new workbook, the date in the sheet that I am copying to new book does not stay the same. For example, I am copying a sheet with date 1/8/2010 in a cell. On the new sheet that is copied to a new workbook, that date changes to 1/9/2014. All of the other data on sheet stays the same but all the dates on the page change. Other dates at the bottom of the page advance to 1/8/2013.

If I perform this on a PC, all of the dates remain the same. I just talked to another recent convert and he has the same problem.

I am going nuts trying to figure this one out.
Any ideas???
QUOTE Thanks
nabl

 
nabl's Avatar
 
Member Since: Dec 13, 2007
Location: United States of America
Posts: 256
nabl has a spectacular aura about
Mac Specs: 2.1GHz MacBook with 4GB RAM, Mac OS X 10.6, iLife and iWork 09

nabl is offline
Excel stores dates internally as the number of days since a base date. The problem for you is that the base date is different between the Windows and Mac versions of Excel: on Windows, the base date is January 1, 1900, while on Macs it's January 2, 1904. So what's happening is that the same number of days is being counted, but it's being added to a different date. You can read more about it in Excel's documentation for the DATE function.

To fix it (on a per-workbook basis), choose Excel > Preferences from the menu bar and then click the Calculation section. Uncheck the Use the 1904 date system option and you should be good to go; just keep it in mind when using dates and transferring files between Windows and Mac users.
QUOTE Thanks
technologist

 
Member Since: Mar 30, 2004
Location: USA
Posts: 4,744
technologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond repute
Mac Specs: 12" Apple PowerBook G4 (1.5GHz)

technologist is offline
XL: The 1900 Date System vs. the 1904 Date System

Basically, yeah, what nabl said.
QUOTE Thanks

Post Reply New Thread Subscribe


« Defrag: not beating a dead horse lol | Photoshop and Office serial key length help »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Numbers - transferring data from sheet to sheet VIPeR OS X - Apps and Games 6 11-27-2009 11:50 AM
The question game! Sydrocentric Schweb's Lounge 28 06-13-2009 04:21 AM
The QUESTION Game ToddG Schweb's Lounge 159 08-15-2007 05:25 PM
Ask 'me' a question... eric Schweb's Lounge 22 01-12-2007 06:33 AM
Excel attachment huffstar Running Windows (or anything else) on your Mac 12 06-03-2004 12:16 PM

All times are GMT -4. The time now is 12:41 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?