I need numbers in given cells to multiply by a constant number

[normanluc]

I have a worksheet where I will add different numbers in a column each month. Each month I need those numbers to be multiplied by 25%. How to I put a formula in the cells to tell it to multiply by 25% whenever I enter an amount in that cell? thanks

[Moo the Dog]

You can add a formula in an adjacent column. If you add your data in column A1, then in column B1 add the formula: =A1*.25

Otherwise, you can't store a constant and a formula in the same cell. You can use a macro/VBA to do something like what you want, but that sounds like overkill for something this simple. Unless you absolutely can't have an additional column.

- Moo