 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / PowerPoint / December 2006dates in ppt charts
I'm finding it impossible to head a column with the date '01/02' as it is automatically changed to a date in a different format ('99/00' and 00/01', however are fine). I have tried using a customised number with the format 'yy/yy', which gives a sample of 04/04. However, when I then try and type '01/02' into the cell '04/04' appears! Help please! > I'm finding it impossible to head a column with the date '01/02' as it > is automatically changed to a date in a different format ('99/00' and [quoted text clipped - 3 lines] > gives a sample of 04/04. However, when I then try and type '01/02' > into the cell '04/04' appears! This is a relic and ongoing symptom of Microsoft's 'Mother knows best' attitude. Its software believes it recognises a date being input, and reformats the cell accordingly. That behaviour has been around (and I've complained about it) since Excel v1.1. One answer (in Excel) is to prefix the input with an apostrophe ('), which will force the cell to be formatted as plain text. Unfortunately, in a Graph object in PowerPoint, the apostrophe shows up on the chart. My solution is to type a space before each such input (any pair of one- or two-digit numbers separated by a slash or hyphen). The space will at least be invisible on the plotted chart. HTH! Gareth.  SignatureFrom Gareth John Please pull out the plug if you want to reply by email > > I'm finding it impossible to head a column with the date '01/02' as it > > is automatically changed to a date in a different format ('99/00' and [quoted text clipped - 20 lines] > > Gareth. Darnit. A much simpler answer, which I should have pointed out first, is to select the range of header cells in your Graph datasheet, and do Format: Number: Text. Gareth J. SignatureFrom Gareth John Please pull out the plug if you want to reply by email > > > I'm finding it impossible to head a column with the date '01/02' as it > > > is automatically changed to a date in a different format ('99/00' and [quoted text clipped - 29 lines] > From Gareth John > Please pull out the plug if you want to reply by email > > > I'm finding it impossible to head a column with the date '01/02' as it > > > is automatically changed to a date in a different format ('99/00' and [quoted text clipped - 29 lines] > From Gareth John > Please pull out the plug if you want to reply by email Brilliant! Thanks > > > I'm finding it impossible to head a column with the date '01/02' as it > > > is automatically changed to a date in a different format ('99/00' and [quoted text clipped - 29 lines] > From Gareth John > Please pull out the plug if you want to reply by email Brilliant! Thanks > > > I'm finding it impossible to head a column with the date '01/02' as it > > > is automatically changed to a date in a different format ('99/00' and [quoted text clipped - 29 lines] > From Gareth John > Please pull out the plug if you want to reply by email |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.