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

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

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

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524560

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

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


"Shanon" wrote:

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