Search Contextures Sites

Excel Tutorial Videos 02 Name a Range of Cells  Stop the Macro Warning After Macros Deleted  Convert Text Numbers to Real Numbers  Name a Range of Cells In Excel, you can create names that refer to a single cell, a group of cells on the worksheet, a specific value, or a formula. After you define Excel names, you can use the names in a formula, instead of using a constant value or cell references. For example, a cell that contains the tax rate could be named SalesTax. Then, other cells could multiply sales amounts by the named range, SalesTax. For Excel names that refer to a cell or a range of cells, you can use the names to quickly select the named range, and that makes navigation easier. Just select a range name from a drop down list, and you'll immediately go to that range. For written instructions for this Excel tutorial, see: Naming a Range Stop the Macro Warning After Macros Deleted If you open an Excel file, you might see a message that asks if you want to "Enable or Disable a Macro". However, you might be confident that there are no Excel macros in this workbook. This message appears if an Excel macro has been added and then removed, leaving an empty module. An empty module will trigger the macro warning, even though all the macros have been removed from the module.. In this video you'll see how to find the cause of the problem message, and remove the problem modules. For written instructions for this Excel tutorial, see: Macro Warning Convert Text Numbers to Real Numbers When you copy data from another program, such as Microsoft Access, or from a text file, Excel may treat the numbers as text. If you perform calculations with these numbers, the calculations will be incorrect, such as a column of "numbers" that adds up to zero. This video shows one of the methods that you can use to convert the text "numbers" to real numbers. You'll use the Paste Special command to multiply the text numbers by zero. That will change them to real numbers, that you can use in calculations. For written instructions for this Excel tutorial, and other methods for converting text numbers to real numbers, see: Convert Numbers

	Excel Tutorial Videos 01 Excel Tutorial Videos 02 Excel Tutorial Videos 03 Excel Tutorial Videos 04 Excel Tutorial Videos 05 Excel Tutorial Videos 06 Excel Tutorial Videos 07 Excel Tutorial Videos 08  Excel Tutorial Videos 09  Excel Tutorial Videos 10

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact
Privacy Policy		Contextures Inc., Copyright © 2009. All rights reserved.	Debra Dalgleish

Last updated: January 27, 2010 11:03 AM