text

Wed
28
May
Dennis Faas's picture

Converting Dates in MS Excel

A reader asked if there was any formula in Excel that would convert a date shown in the European format of day-month-year to the U.S. version of month-day-year. Technically, it may not be necessary to do this. Excel maintains dates as numeric values ... and displays them using various formats. If the dates are numeric values in your worksheet, then you can simply change the format and the dates will be displayed in the U.S. format. The day you see in a worksheet could instead be a text value rather than a numeric value. To see if the date is truly an Excel date or text value, you can change the ... (view more)

Thu
15
May
Dennis Faas's picture

Find it Over and Over Again in MS Word

If you use the Find feature in MS Word, you know how very helpful it can be, but if you keep trying to find the same word or phrase multiple times, you most likely have found, as I have, that the Find window sometimes is in your way and you have to ... move it to get a good look. A lot of folks that I have spoken to about this have said that they find it much easier to just leave that Find window open and hitting Find Next rather than to keep opening the window. That is true, but there is an easier solution that you can use! Follow the steps below:Click on Edit | Find (or use the quick key ... (view more)

Tue
22
Apr
Dennis Faas's picture

'Nexus File', and 'Incorporate Text Files Onto Your Desktop'

Nexus File NexusFile is a file manager for Windows that will increase your computing performance. If you still use Windows Explorer, you must try this exciting tool with far too many features to list here. http://www.xiles.net/ Incorporate Text ... Files Onto Your Desktop If you keep your daily worklog, grocery shopping list, to-do's, project ideas, or even your calendar in text files, you can embed that information right onto your Windows desktop. http://lifehacker.com/ (view more)

Tue
15
Apr
Dennis Faas's picture

Cell Phones Could be Used for Emergency Alerts

Remember those annoying TV interruptions testing the Emergency Broadcast System? Well, now federal regulators have approved a plan that would make your cell phone part of the emergency alert system by allowing blanket text messages to be sent to all ... cell subscribers within a given geographic area. Although cellular customers would be allowed to "opt-out" of the plan, the Warning Alert and Response Network Act of 2006 required the FCC to upgrade the ways the public can be alerted about emergencies. With more than 200 million cell phones in use in the U.S., and with texting becoming more ... (view more)

Mon
07
Apr
Dennis Faas's picture

Amazon Launches Buy-By-Text Scheme

Amazon has launched a new service allowing customers to buy products via their cell phones. Those who've tested it say the service works smoothly...but is a complete waste of time. The scheme works by allowing customers to text the name of a ... product, the ISBN (for books) or the Universal Product Code (the barcode number for other products) to 262966, which spells out Amazon on keypads. They then receive a text message back with the first two products that match the search and text either 1 or 2 to make their selection, or M for more options. First time users will then need to text the email ... (view more)

Fri
04
Apr
Dennis Faas's picture

Insert a Line Above Your Table in MS Word

You create a table in your document at the top of the page and it looks great! But now you or your superior decide that there should be text before the table. Not as easy as you thought it was going to be, is it? I know you tried clicking above the ... table, but it doesn't work, does it? Before you drive yourself batty trying to do it, or worse yet retype your text, let me show you how to resolve this maddening problem. I promise you that it is quick and easy. Follow the steps below: Click in the upper left cell of the table before the text. Then just hit the Enter key. Told you it was quick and ... (view more)

Thu
31
Jan
Dennis Faas's picture

Make Sure your Copied Text is Clean in MS Word

Many times we copy text from some place on the Internet and then blithely paste it into our half-finished Word document to complete a report for someone in our office. But now it doesn't look quite right and you cannot seem to edit it for some ... reason! That is because when you copy the text from a Web page or another document, you bring the source's formatting from what you copied into your document. Follow the steps below to prevent that from happening when you copy and paste text: Click in your document where you want to paste the text that you have just copied. Click on Edit | Paste | Paste ... (view more)

Wed
19
Dec
Dennis Faas's picture

AutoComplete in MS Word 2007

Recently a reader wrote to me with an query about AutoComplete in MS Word. Below is the query: "To insert today's date (and/or time) in Word 2007 you are supposed to be able to type the first four characters of the month and AutoComplete will assist ... you. This does not work for me. It is like AutoComplete is not tripped in my Word 2007. Also, when I click on Insert I find nowhere to insert the date from. I have to admit I am a fish out of water with MS Word 2007." -- Mark My reply: Well Mark, you are not the only person who feels like a fish out of water with this newest version of Word but ... (view more)

Fri
02
Nov
Dennis Faas's picture

Change The Angle Or Orientation Of Text In Excel 2007

You have no doubt seen spreadsheets and charts that had diagonal or vertical text, I am sure. If so, I am sure that you will agree that it is very impressive. It also will allow you to display more information in less space. You will be pleased to ... know that it is very easy to accomplish in Excel 2007. Follow the steps below to learn how: Launch MS Excel 2007 if it isn't already open. Type your text into a cell. Select the cell. On the Home tab of the Ribbon, find the Alignment group. In that group, you will see a button with an a and b and an arrow all on an angle. That is the Orientation ... (view more)

Fri
12
Oct
Dennis Faas's picture

Selecting Text Orientation for an Axis in Microsoft Graph: MS Word

When you are working with a Chart in MS Graph, you may sometimes want to change how text appears on an axis, such as changing the text from horizontal to vertical. Fortunately, MS Graph has made it easy to accomplish. Follow the steps below: Select ... the axis where you want to change the text. You can do this by clicking on the axis with your mouse. You can also right-click on the axis and select Format Axis. Choose Selected Axis from the Format menu. MS Graph will display the Format Axis dialog box. Be sure that the Alignment tab has been selected. Specify an orientation for the text in ... (view more)

Pages

Subscribe to RSS - text