How do you multiply each cell by the same number? ( 899.80*.085)

S

Shanon

i am having to convert dollars from a annual base to a monthly base and I
need to know how to change each cell to the product of .085.
Example: 899.80*.085= 76.48.
Please help
 
S

SteveG

Type .085 in a blank cell. Copy it. Highlight the range of cells to be
multiplied by .085. Go to Edit, Paste Special, in the Operation section
select Multiply. Click OK.


HTH

Steve
 
R

Ron Coderre

To convert from Annual to Monthly, wouldn't you rather divide by 12?

TO DIVIDE:
Enter the number 12 in a blank cell
<Edit><Copy>
Select the cells to be impacted
<Edit><Paste Special>
Check: Divide
Check: Values
Click the [OK] button

TO MULTIPLY:
Enter the number 0.085 in a blank cell
<Edit><Copy>
Select the cells to be impacted
<Edit><Paste Special>
Check: Multiply
Check: Values
Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top