[August 1, 2010]

Wow! Is July really gone??? Where did it go??? I feel like I have to hurry up and enjoy the rest of summer and that kind of defeats the whole purpose of summer doesn't it?

We are very busy in my family. My son is being married in October so there is a real flurry of activity such as bridal showers, invitations to be addressed, gowns to be bought as well as tuxes to be rented, rehearsal dinners to be planned, etc.

We are also expecting our very first grandchild in January! Anyone who knows me knows how busy I am preparing for that! Hats and blankets to be knitted and crocheted, baby showers to plan, maternity clothes to be bought for my daughter! I guess it's no wonder the summer is flying past me!!!

Please be aware that Microsoft has announced that free support has now been withdrawn for Office 2003. They will start to phase out tips and tricks for Office 2003 over the next few months. Paid support, of course, will remain available to everyone but the Microsoft tips and training sites will now focus on versions 2007 and 2010. So if any of your friends, co-workers or colleagues are still using and plan to continue to use Office 2003 steer them to our newsletter. Yes, we will begin phasing in tips and tricks for Office 2007 and 2010 but we won't forget the folks still using version 2003!

I hope that everyone else is taking the time to really enjoy this summer. It's one of the hottest ones I remember in quite a while. The flowers needed double watering and the cat needed an overhead fan to be comfortable and she loves a good sunbeam but who doesn't?

The quote for the day is:

Beauty without virtue is as a flower without perfume --- French proverb

Please join me now in welcoming Jacquelyn, Jane and Evaline, as the latest premium subscribers to Carol's Word Bytes Newsletter. Welcome to the family! I am trying to reach a million subscribers so, if you know someone who struggles with an application in Microsoft Office, like Word or Excel, do them a favor and tell them about our newsletter. They will be grateful to you for helping them!

Let's get to the tips now!

Carol's Signature

Table of Contents

Change the Default Date Separator from Slash to Dot in MS Excel - Have it your way!

Cancel Update Links Message When Opening Linked Workbook - So easy!

Insert One PDF File into Another PDF File in Acrobat 2009 - Cool stuff to know!

Word 2007 audio course buy word 2007 audio course

Change Default Date Separator from Slash to Dot

MS Excel recognizes a number as a date by its date format, which uses a slash (/) as a separator. If you key in 8/1/2010 it is recognized as a date by MS Excel.

Follow the steps below to change the default setting for the date format:

  1. From the Windows Start menu, select Settings | Control Panel | Regional and Language Options.
  2. In Regional Options, select Customize.
  3. Select the Date tab.
  4. In the Date Separator dropdown list, change the slash (/) to a dot (.).
  5. Click Apply.
  6. Click OK.

Return to Table of Contents

LaptopToys.net
Laptop Toys - Laptop Cooling

Cancel Update Links Message When Opening Linked Workbook

Follow the steps below to cancel the Update Links message while Opening a linked workbook:

  1. Click on Tools | Options.
  2. Click the Edit tab.
  3. Deselect the Ask to update automatic links checkbox.
  4. Click OK.

In versions 2002 and 2003:

  1. Select one of three new options in the Starup Prompt dialog box:
  2. Click on Edit | Links.
  3. Click Startup Prompt.
Bookmark and Share

Return to Table of Contents

Insert One PDF File Into Another PDF File

Ins Adobe Acrobat you can insert or replace a page, a specified range of pages or all pages from one PDF document into another.

Follow the steps below to learn how:

  1. With the Hand tool selected, click the Bookmarks button in the navigation pane to display the bookmarks.
  2. Drag in the scroll bar in the document pane to go to page 3 (3 of 5) in the document, or click the A Look Inside Bookmark icon in the Bookmarks panel.
  3. Select Document | Insert Pages from the File menu in MS Windows or Document | Insert Pages using the Mac OS.
  4. In the Select File To Insert dialog box, navigate to the pdf file you want to insert and click Select.
  5. In the Insert Pages dialog box, for location, choose either before or after to suit your purposes.
  6. Make sure that Page is selected and that the Page text box contains 3.
  7. Click OK.

The pages are inserted where they belong.

Bookmark and Share

Return to Table of Contents

Included in the Premium Newsletter:

  • More About Track Changes in MS Word
  • Quick Paste in MS Excel.
  • Print Notes with your PowerPoint Presentation
  • Utilizing Text Boundaries in MS Word
  • Send an E-mail to an Undisclosed Recipient in MS Outlook
  • Re-write History in MS Excel

Shouldn't you be a premium subscriber?? With a premium subscription, you get more than double the content and NO advertising! Plus, most instructions come with clear screenshots! With your premium subscription you also receive access to an archive of five years of newsletters and deep discounts on all books and tutorials I publish!! So what are you waiting for? Sign up today!

Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.