Mobile/PDA About Us Advertise here
User User name Password  
  Not registered yet? Register here.
Lost your password? Click here. 		 
  Home   News   Guides   Downloads   Glossary   Hardware   Profiles   Forums   v4  
 Advertise at AfterDawn.com     Link to us!     Private messages     Compose a private message     List of all updated threads     Threads without replies     Search messages
Monday 4.5.2026 / 01:06
Search AfterDawn Forums:        In English   Suomeksi   På svenska
afterdawn.com > forums > software, operating systems and more > windows - software discussion > excel date function
Show topics
 
Forums
Forums
excel date function
  Jump to:
 
Posted Message
gretel
Suspended due to non-functional email address
_ 		1. June 2006 @ 14:43 _ Link to this message    Send private message to this user   
Is this a version problem: I have a large spreadsheet with a date field - need to copy parts to another worksheet or workbook. When I copy a date it is change in the destination cell. Most common change is to keep same month, day one less, and year four years less. So 01/18/06 becomes 01/17/02. Doesn't matter what date format. Just happens over and over and never copies correctly.
[ + quote]
Advertisement
_ 		__
TomMelee
Senior Member
_ 		1. June 2006 @ 16:21 _ Link to this message    Send private message to this user   
If you mouseover the cell after pasting, there should be a little white plus sign w/ a drop down arrow. If you click that, there should be a list about how to take the paste...keep formatting, paste data only, etc.

I would experiment w/ that, sometimes you need to change it from default.

<edit> it could also very likely be that your cmos clock and/or system clock is...well...wrong.
[ + quote]

This message has been edited since posting. Last time this message was edited on 1. June 2006 @ 16:21
gretel
Suspended due to non-functional email address
_ 		1. June 2006 @ 17:32 _ Link to this message    Send private message to this user   
OK thanks - as I looked at it again - seems like the difference between the 1900 and 1904 date rules - just need to figure out how to change the one workbook to the same setting as all the rest in my system
[ + quote]
gretel
Suspended due to non-functional email address
_ 		1. June 2006 @ 18:25 _ Link to this message    Send private message to this user   
shouldn't have started this, I guess. I found a check box: in excel tools, options, calculations, 1904 date - seems MACs sometimes use the 1904 convention. Made me a bit nuts. That's all
[ + quote]
Advertisement
_ 		__
 
_
TomMelee
Senior Member
_ 		1. June 2006 @ 19:15 _ Link to this message    Send private message to this user   
Oh...well...good then.
[ + quote]
The BT Bible 1.2, no longer hosted on rapidshare!:
http://www.plucky.org/component/option,com_vfm/Itemid,54/

Static? Dynamic? What's wrong with your torrent? Tweaks? Fixes? Troubleshoots? All that and more...
http://www.plucky.org
afterdawn.com > forums > software, operating systems and more > windows - software discussion > excel date function
 

Digital video: AfterDawn.com | AfterDawn Forums
Music: MP3Lizard.com
Gaming: Blasteroids.com | Blasteroids Forums | Compare game prices
Software: Software downloads
Blogs: User profile pages
RSS feeds: AfterDawn.com News | Software updates | AfterDawn Forums
International: AfterDawn in Finnish | AfterDawn in Swedish | AfterDawn in Norwegian | download.fi
Navigate: Search | Site map
About us: About AfterDawn Ltd | Advertise on our sites | Rules, Restrictions, Legal disclaimer & Privacy policy
Contact us: Send feedback | Contact our media sales team
 
  © 1999-2026 by AfterDawn Ltd.

  IDG TechNetwork