[May 15, 2010]
The weather has been absolutely lovely in my region of the country. It has felt like Summer rather than Spring for the last week or two. Well that all changed on Saturday evening. Wow, the temps dropped and last night the temperature went right down to the forties. A bit nippy for Springtime! But I suppose in a week or so it will be balmy once again. Right now we are saving on our air conditioning bills.
I am still taking my early morning walks and they continue to be very enjoytable. I find it very helpful to ease into my day in this manner. I arrive back at the office full of energy and in a good frame of mind. You should try it and see if you don't like it too. I have been trying to find ways to put more activity into my days and I have been sleeping well as a result.
I am continuing to wade through my e-mail and attempting to answer any inquiries that have been sent me, so I hope that you will continue to be patient if you have not yet received a reply to any e-mails you have sent my way.
The quote for the day is: Opportunity knocks but once, but temptation bangs on your door all the days of you life.
Please join me now in welcoming James K., Stephen S., Tom F., Jo C., Paul D., Minocher P., Sally S., David R., and Christine D., as the latest premium subscribers to Carol's Word Bytes Newsletter. Welcome to the family! 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 always thank you for it!
Let's get to the tips now!
Table of Contents
A Free Way to Make Office 2007 Have the Classic Look - Have it your Way!
Convert Uppercase to Lowercase in Excel Worksheet - So easy!
Customize the Default Date Separator in MS Excel - Your way again!
 |
|
A Free Way to Make Office 2007 Have the Classic Look
UBitMenu is a simple and free way to bring back the classic 2003 menus and toolbars to your Office 2007 programs.
You will get all the traditional pull down menus plus two long rows of toolbar buttons. The menus are mostly the same as you were used to in Office 2003 with some minor changes to allow for the 2007 improvements. There is no Most Recently Used (MRU) List but that is a minor inconvenience and you can go back to the Office button for that.
This little utility installs easily and has hardly any impact on performance. You can download it here for free. For easy setup, select the .exe version for your preferred language, download and install.
A corporate version is also available for a very reasonable fee.
Convert Uppercase to Lowercase in Excel Worksheets
Use the LOWER function to convert all uppercase letters in a text string to lowercase. The LOWER function is in the Text category in the Insert Function dialog box.
For instance, if you have CAROL A. BRATT in cell A1, use this formula:
=LOWER(A1)
The result will be carol a. bratt.
Customize the Default Date Separator in MS Excel
MS Excel recognizes a number as a date by its date format, which uses a slash as a separator.
To change the default setting for the date, follow the steps below:
- Click on Start | Settings | Control Panel | Regional and Language Options.
- In Regional Options, select Customize.
- Select the Date tab and in the Date separator drop-down list, change the slash to a dot.
- Click Apply
- Click OK.
That's it! Very easy!
Included in the Premium Newsletter:
- Background printing in MS Word
- Merge Or Center Cells in MS Excel
- Jump From Table To Table in MS Word Quickly
- Create Charts Quickly in MS Excel 2007 and 2010
- Great Google Search Tips
- Extend Selection 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.