ExcelTips (Menu Interface)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our site focusing on the ribbon interface.
ExcelTips FAQ
Ask an Excel Question
Make a Comment
Free Business Forms
Free Calendars
It is not uncommon to need to adjust values imported from a different program, once they are in Excel. For instance, you may need to divide all the imported values by 100 or by 1000, or by some other number.
There is an easy way to perform such an operation in Excel. Simply follow these steps:
That's it! All the values in your data range have been divided by the appropriate amount.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2658) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Related Tips:
Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates. Check out Timesheet Templates today!