custom date format in PowerPoint?
Dick Margulis
So, okay, I know how to customize the date format in Word, but PowerPoint isn't Word.
Anyone out there a wiz who can tell me how to either (a) access someplace in PowerPoint where I can tweak this or (b) OLE insert the field from Word, so that it automatically updates every day or (c) do something else that will relieve the receptionist of the onerous <g> task of typing the date manually each day?
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Collect Royalties, Not Rejection Letters! Tell us your rejection story when you
submit your manuscript to iUniverse Nov. 6 -Dec. 15 and get five free copies of
your book. What are you waiting for? http://www.iuniverse.com/media/techwr
Your monthly sponsorship message here reaches more than
5000 technical writers, providing 2,500,000+ monthly impressions.
Contact Eric (ej...@raycomm.com) for details and availability.
---
You are currently subscribed to techwr-l as: tech...@GTS.ORG
To unsubscribe send a blank email to leave-tech...@lists.raycomm.com
Send administrative questions to ej...@raycomm.com. Visit
http://www.raycomm.com/techwhirl/ for more resources and info.
John Posada
has for other issues....
Create the date format in a Word document how you want it, then copy
the whole formula to clipboard and paste it in the PowerPoint.
I know it comes in as a "formula", I just don't know if it will
update the way you want.
--- Dick Margulis <marg...@mail.fiam.net> wrote:
| Our receptionist is using PowerPoint to run a daily events calendar
| slide show in our lobby. She wants it to include an automatically
| updated date field in the format "Tuesday, 4 December 2001."
=====
John Posada, Senior Technical Writer
mailto:jo...@tdandw.com, 732-259-2874
__________________________________________________
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
Darren Barefoot
I just had a quick look at this issue and it looks like the following might
work:
On the Insert menu, click Date and Time. Ensure that Date and Time is
selected, and click Update Automatically. This will insert the current date
in a footer. Not ideal, but a decent start.
As an alternative possible solution, you could create a Word document that
only contains the date and time (as John describes), and instead of cutting
and pasting it, inserting it as an object (Using the Object command on the
Insert menu). That might work, but I'd have to wait until tomorrow to find
out.
Those are both possibilities. Hope that helps. DB.
Darren Barefoot
Technical Writer
Cape Clear Software
www.capeclear.com
| -----Original Message-----
| From: John Posada [mailto:jpos...@yahoo.com]
|
|
| Just an outside chance...I don't know if it works for this,
| but it has for other issues....
|
| Create the date format in a Word document how you want it,
| then copy the whole formula to clipboard and paste it in the
| PowerPoint.
|
| I know it comes in as a "formula", I just don't know if it
| will update the way you want.
|
| --- Dick Margulis <marg...@mail.fiam.net> wrote:
| > Our receptionist is using PowerPoint to run a daily events calendar
| > slide show in our lobby. She wants it to include an automatically
| > updated date field in the format "Tuesday, 4 December 2001."
|
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Collect Royalties, Not Rejection Letters! Tell us your rejection story when you
submit your manuscript to iUniverse Nov. 6 -Dec. 15 and get five free copies of
your book. What are you waiting for? http://www.iuniverse.com/media/techwr
Have you looked at the new content on TECHWR-L lately?
See http://www.raycomm.com/techwhirl/ and check it out.
John Posada
| is
| selected, and click Update Automatically. This will insert the
| current date in a footer. Not ideal, but a decent start.
I think the issue is not to create a date that auto updates, but one
in the specific format required. The one that most resembles the
required format has the day and month reversed...correct?
| As an alternative possible solution, you could create a Word
| document that
| only contains the date and time (as John describes), and instead of
| cutting
| and pasting it, inserting it as an object (Using the Object command
| on the
| Insert menu). That might work, but I'd have to wait until tomorrow
| to find out.
If you do it this way, doesn't Word require that the page with the
formula must be opened for it to roll over to the next date?
=====
John Posada, Senior Technical Writer
mailto:jo...@tdandw.com, 732-259-2874
__________________________________________________
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Collect Royalties, Not Rejection Letters! Tell us your rejection story when you
submit your manuscript to iUniverse Nov. 6 -Dec. 15 and get five free copies of
your book. What are you waiting for? http://www.iuniverse.com/media/techwr
Your monthly sponsorship message here reaches more than
5000 technical writers, providing 2,500,000+ monthly impressions.
Contact Eric (ej...@raycomm.com) for details and availability.
---
Darren Barefoot
| To: TECHWR-L
| Subject: RE: custom date format in PowerPoint?
|
|
|
| > As an alternative possible solution, you could create a
| Word document
| > that only contains the date and time (as John describes),
| and instead
| > of cutting
| > and pasting it, inserting it as an object (Using the Object command
| > on the
| > Insert menu). That might work, but I'd have to wait until tomorrow
| > to find out.
|
| If you do it this way, doesn't Word require that the page
| with the formula must be opened for it to roll over to the next date?
|
I was hoping that when you spawned PowerPoint, it would open all inserted
objects...no such luck. I just tested my solution and it doesn't work.
Though, if you were really fancy, you could write a macro that, when that
PowerPoint document was launched, automagically opened and closed the
associated Word document to update the date field. That might be overkill,
though.
Ah-hah! Forget all that macro stuff. I (believe it or not) looked in the
help and found the following:
**Add date and time or slide number anywhere on a slide**
1. On the slide, position the insertion point in the placeholder or text box
that you want to add the date and time or slide number to.
2. On the Insert menu, click either Slide Number or Date and Time.
When you do this, there's a Update Automatically check box in the Date and
Time dialog box that opens. This will update every time the file is opened.
I believe that'll do it. Third time lucky maybe? Thanks. DB.
Dick Margulis
Thanks, but that gets me back to the original quandary, which is that PowerPoint doesn't offer the date format we're looking for as an option.
I just tried creating in Word and then Pasting Special in PowerPoint. I did it as a link, hoping it would update, but no such luck. (I saved, closed, and reopened the Word doc on a different date--changed my system calendar--and the Word doc updated. Then I reopened the PPT, but it still had the previous date.)
So, still no luck.
Dick
Darren Barefoot
macro route is the best I can come up with at this point--note that the
macro has to open the Word document via PowerPoint. Thanks. DB.
| -----Original Message-----
| From: Dick Margulis [mailto:marg...@mail.fiam.net]
| Sent: 04 December 2001 16:19
| To: TECHWR-L; Darren Barefoot
| Subject: RE: custom date format in PowerPoint?
|
|
SIA...@visus.jnj.com
Insert>>Object>>Microsoft Excel Worksheet.
Crop it to show only one cell (sized to accommodate the date).
Click in the cell and Format it as desired.
(go to format>>cell>>number tab>>Date,
pick one with the elements you need,
then switch to Custom and re-order them as desired)
Hit OK.
Verify you're still in the target cell.
Insert>>Function and select TODAY and hit OK.
(or enter =TODAY() in the cell)
Center it if desired (sounds preferable, from your desc).
Now exit the Excel editor, and move the block to wherever you need it on
the page.
HTH,
Shauna Iannone
--------------
Sleep is for the weak,...just not *this* week.
John Posada
can give you a date that will automatically update and you do
nothing, ever, but instead of Tues, 4 December 2001, I can give you
Tues, December 4, 2001" that she wouldn't say "oh, OK..."
Is it THAT important that the day be on the left instead of the
right? If so, must not be that big of a deal to her in the first
place.
--- Dick Margulis <marg...@mail.fiam.net> wrote:
| Darren,
|
| Thanks, but that gets me back to the original quandary, which is
| that PowerPoint doesn't offer the date format we're looking for as
| an option.
=====
John Posada, Senior Technical Writer
mailto:jo...@tdandw.com, 732-259-2874
__________________________________________________
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Tracy Boyington
it. (sigh)
~~~~~
Tracy Boyington tracy_b...@okcareertech.org
Oklahoma Department of Career & Technology Education
Stillwater, OK http://www.okcareertech.org/cimc
|>> John Posada <jpos...@yahoo.com> 12/04/01 10:54AM >>>
Dick...I find it hard to believe that if you went to her and said "I
can give you a date that will automatically update and you do
nothing, ever, but instead of Tues, 4 December 2001, I can give you
Tues, December 4, 2001" that she wouldn't say "oh, OK..."
Is it THAT important that the day be on the left instead of the
right? If so, must not be that big of a deal to her in the first
place.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Collect Royalties, Not Rejection Letters! Tell us your rejection story when you
submit your manuscript to iUniverse Nov. 6 -Dec. 15 and get five free copies of
your book. What are you waiting for? http://www.iuniverse.com/media/techwr
Have you looked at the new content on TECHWR-L lately?
See http://www.raycomm.com/techwhirl/ and check it out.
---
Dick Margulis
Ugly, perhaps, but it works.
---------- Original Message ----------------------------------
From: SIA...@VISUS.JNJ.com
Reply-To: SIA...@VISUS.JNJ.com
Date: Tue, 4 Dec 2001 9:55:14
|Found a somewhat ugly way:
|
|
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Collect Royalties, Not Rejection Letters! Tell us your rejection story when you
submit your manuscript to iUniverse Nov. 6 -Dec. 15 and get five free copies of
your book. What are you waiting for? http://www.iuniverse.com/media/techwr
Your monthly sponsorship message here reaches more than
5000 technical writers, providing 2,500,000+ monthly impressions.
Contact Eric (ej...@raycomm.com) for details and availability.
---
John Posada
person before me did it that way and I didn't know it was OK to
change it." Sometimes they'll surprise you.
The only justification I can think of for doing it that way is some
countries other than US put the day before the the month...Dick...are
you outside of the US?
--- Tracy Boyington <tracy_b...@okcareertech.org> wrote:
| Oh, John, I know some people you need to meet... *then* you'll
| believe
| it. (sigh)
=====
John Posada, Senior Technical Writer
mailto:jo...@tdandw.com, 732-259-2874
__________________________________________________
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
ed...@transport.bombardier.com
Been deleting this thread, but I read John Posada's post.
"The only justification I can think of for doing it that way is some
countries other than US put the day before the the month...Dick...are
you outside of the US?"
One other justification is that your company is ISO registered. The ISO standard
for dates is YYYY-MM-DD or YYMMDD with the hyphens optionally replaced with
backslashes or omitted altogether.
Another justification is it's the best way to write dates for them to sort
correctly in computer directories. Or, perhaps some of the intended audience is
outside the US and they wish to adopt one standard.
Eric L. Dunn
John Posada
| to sort
| correctly in computer directories. Or, perhaps some of the intended
Then doesn't the date needs to be Tues., 04 December 2001
Without the leading zero, you will probably get:
1
10
11
12
13
14
15
16
17
18
19
2
20
21
etc
Right?
=====
John Posada, Senior Technical Writer
mailto:jo...@tdandw.com, 732-259-2874
__________________________________________________
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Dave Brown
The 'Long Date' field in Power Point (at least for PP97) is determined by the 'Long Date Style' setting on the Date tab of the Regional Settings Properties in Control Panel.
Change your 'Long Date Style' to dddd, d MMMM yyyy on the machine which is displaying the slide show.
--
Regards,
Dave Brown d8¬)»
Dick Margulis wrote:
| Our receptionist is using PowerPoint to run a daily events calendar slide show in our lobby. She wants it to include an automatically updated date field in the format "Tuesday, 4 December 2001." Unfortunately, that's not one of the choices PowerPoint offers.
|
| So, okay, I know how to customize the date format in Word, but PowerPoint isn't Word.
|
| Anyone out there a wiz who can tell me how to either (a) access someplace in PowerPoint where I can tweak this or (b) OLE insert the field from Word, so that it automatically updates every day or (c) do something else that will relieve the receptionist of the onerous <g> task of typing the date manually each day?
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Collect Royalties, Not Rejection Letters! Tell us your rejection story when you
submit your manuscript to iUniverse Nov. 6 -Dec. 15 and get five free copies of
your book. What are you waiting for? http://www.iuniverse.com/media/techwr
Your monthly sponsorship message here reaches more than
5000 technical writers, providing 2,500,000+ monthly impressions.
Contact Eric (ej...@raycomm.com) for details and availability.
---
Barbara Barr
"Dave Brown" <david...@tait.co.nz> wrote in message
news:3C0D7CAE...@tait.co.nz...