Got one number you use over and over in a spreadsheet? Make it a constant. On the Formulas tab, click Define Name, and give the cell a name (like "taxrate"). Put a number in that cell. Now you can use the name in a formula (like =( b4*taxrate) instead of referring to the coordinates. You can set up as many named cells as you wish.

Name:  Make a numerical constant.jpg
Views: 47
Size:  13.0 KB