software

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


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: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=524560To convert from Annual to Monthly, wouldn't you rather divide by 12?

TO DIVIDE:
Enter the number 12 in a blank cell
lt;Editgt;lt;Copygt;
Select the cells to be impacted
lt;Editgt;lt;Paste Specialgt;
Check: Divide
Check: Values
Click the [OK] button

TO MULTIPLY:
Enter the number 0.085 in a blank cell
lt;Editgt;lt;Copygt;
Select the cells to be impacted
lt;Editgt;lt;Paste Specialgt;
Check: Multiply
Check: Values
Click the [OK] button

Does that help?

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

XL2002, WinXP-Proquot;Shanonquot; wrote:

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