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