PC Review


Reply
Thread Tools Rate Thread

dates in data sheet not formatting

 
 
etf
Guest
Posts: n/a
 
      1st Sep 2009
I'm pasting in data from Excel and PowerPoint is not recognizing years
between 1999 and 2009. Everything after 1999 comes up as 09. I've tried it as
date and custom to no avail. Any ideas? Thanks.
--
etf
 
Reply With Quote
 
 
 
 
etf
Guest
Posts: n/a
 
      1st Sep 2009
Sorry Steve. I'm using Office 2003. I am copying columns from Excel and
pasting them in the Microsoft Graph data sheet in PowerPoint. The date
formatting changes and I can't get it back. Sometimes all dates change to
1905. I've also checked the formatting in Excel.
--
etf


"Steve Rindsberg" wrote:

> In article <5865563D-2985-48A2-994F-(E-Mail Removed)>, Etf wrote:
> > I'm pasting in data from Excel and PowerPoint is not recognizing years
> > between 1999 and 2009. Everything after 1999 comes up as 09. I've tried it as
> > date and custom to no avail. Any ideas? Thanks.

>
> a) What version of PowerPoint and Excel?
>
> b) Pasting into what? Following what steps? The more exactly you can describe
> what you're doing, the more likely it is that someone will be able to help.
>
>
>
> ==============================
> PPT Frequently Asked Questions
> http://www.pptfaq.com/
>
> PPTools add-ins for PowerPoint
> http://www.pptools.com/
>
> Don't Miss the PPTLive User Conference! Atlanta | Oct 11-14
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate sheet, autonumber sheet, record data on another sheet des-sa Microsoft Excel Worksheet Functions 0 8th May 2008 06:56 PM
"='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 mistewalker Microsoft Excel Worksheet Functions 5 7th Jan 2008 12:36 AM
Dates dates dates dates... SQL and ASP.NET David Lozzi Microsoft ASP .NET 1 30th Sep 2005 03:18 PM
Dates Not Formatting as Dates awacs Microsoft Excel Worksheet Functions 4 13th Sep 2005 10:35 PM
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B Hannes Heckner Microsoft Excel Programming 1 5th Mar 2004 10:10 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:53 PM.