Pete,
Thank you for your suggestion. I see exactly what you're saying and I
agree that will work.
However, I used one cell (B1) in my example, but in reality I have
numerous cells that I need to do this to every day and even though your
method will work, it will take me many hours to do that to every cell.
Can you think of a simpler way to do what you're suggesting to many
cells at the same time?
Again, I thank you for your time and your expertise.

Ron
--
rbane


"Pete" wrote:

You will have to fix the values of today's calculation before you make
changes to A1 or A2. I think the following formula should be entered
into B1:

=$A$1 * $A$2

and format the cell how you would like it. Then, when you have entered
today's values of A1 and A2, copy the formula into C1 ready for
tomorrow, then select B1 and click <copy, then Edit | Paste Special |
Values (check) and OK followed by <Esc or <Enter. The value in B1 is
now fixed, and the same value will be shown in C1. Tomorrow you can
change A1 or A2 and C1 will also change - copy this to D1 then fix the
values in C1, etc.

Hope this helps.

Pete