bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Tools > Spelling and Grammar Checking > Allowing for Words that Contain Numbers

Allowing for Words that Contain Numbers

Summary: When Excel does a spell-check of the information in a worksheet, you may want it to ignore words that contain numbers. All it takes is a simple change to the configuration options for the spell-checker. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Have you ever noticed that one of the side effects of our fast-paced world is the creation of new words? It seems that every day—particularly in the technological or medical fields—that new words are bursting forth on the scene. Some of these words are actually composed of letters and numbers together. For instance, b2b is an acronym (word?) meaning business-to-business.

Normally such words would be flagged by Excel's spelling checker as being incorrect. If you create worksheets that contain quite a few words that are formed by mixing letters and numbers, you may want to instruct Excel to ignore them. You can do so by following these steps if you are using a version of Word prior to Word 2007:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the Spelling tab is selected. (Click here to see a related figure.)
  3. Make sure the Ignore Words with Numbers check box is selected.
  4. Click on OK.

If you are using Excel 2007 then the steps are a bit different:

  1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
  2. Click Proofing at the left side of the dialog box. (Click here to see a related figure.)
  3. Make sure the Ignore Words that Contain Numbers check box is selected.
  4. Click on OK.

Tip #3380 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007


Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!
 
Check out ExcelTips Archives today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)