|
|
Solve an iWork/Excel data paste and charting glitch
I have not tried this, but why not simply format your dates as "text" within Excel? There are two ways to do this, one on data entry and one with a collection of cells.
As you enter data you'd like Excel to interpret as a string, precede the data with a left quote. That is, type '1997 in the cell for year "1997." You'll know that Excel is treating it as a string as the text "1997" will be left-justified instead of right-justified. Alternatively, enter all your years as numbers (or strings when typing "2004e"), then highlight the cells and select "Cells..." from the Format menu in Excel. Choose "Text" and all your dates will be left-justified strings again. As I mentioned I have not tested this solution, so it is possible that Keynote and/or Pages will be a bit too clever and automatically convert the text strings of numbers into integers (i.e. data) -- but if not the above should work fine. HTH.
Solve an iWork/Excel data paste and charting glitch
I actually tried that first -- both formatting as text, and using the single quote.
Solve an iWork/Excel data paste and charting glitch
I never really paid attention to Keynote or Pages until I saw that nice chart image you posted, Rob. Now I've gotten iWork; Apple should thank you! I do. |
SearchFrom our Sponsor...Latest Mountain Lion HintsWhat's New:HintsNo new hintsComments last 2 daysLinks last 2 weeksNo recent new linksWhat's New in the Forums?
Hints by TopicNews from Macworld
From Our Sponsors |
|
Copyright © 2014 IDG Consumer & SMB (Privacy Policy) Contact Us All trademarks and copyrights on this page are owned by their respective owners. |
Visit other IDG sites: |
|
|
|
Created this page in 0.09 seconds |
|