Prev Previous Post   Next Post Next
  #1   Report Post  
MikePiehl
 
Posts: n/a
Default Date Problems

Dear Microsoft:
Since we all know that the cost of a 1st class stamp is going to go up, I
thought I would plot the cost over time.
http://www.nonprofitmailers.org/tools/ratehist.htm

1. I formatted a column as DATE, but the 3 dates prior to 1900 that I
entered as x-x-xxxx were not recognized by Excel as dates. (??!!???!). When
I reentered them as x/x/xxxx Excel recogized July 1, 1885, but not the other
2. (Huh?)

2. So then I charted the dates and the costs as a line chart, the costs are
displayed ok. The dates are displayed on the x-axis, but the dates are
equidistant. That's not what I had in mind. And when I tried an x-y chart,
it got even more pitiful. (I'd tell you how pitiful, except this "New
Question" window isn't a window, it's commaneered my entire screen . . . )

Really, this is easy. Or am I missing something?

Thanks for your help,
Mike
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with date calculations (bank hols etc) Andy100 Excel Discussion (Misc queries) 3 April 14th 05 05:53 AM
time and date problems still Michaela Excel Worksheet Functions 0 February 7th 05 05:31 PM
Date sort problems Graham_Wright Excel Discussion (Misc queries) 2 January 4th 05 05:00 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM
Using formulas to determine date in one cell based on date in anot Gary Excel Worksheet Functions 2 November 22nd 04 08:11 AM


All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"