Tyn

If this is a one-time operation just enter 1.818 in an unused cell.

EditCopy that cell.

Select all cells with British Pounds and EditPaste Special(in
place)MultiplyOKEsc.

What Bob provided is called a "formula" not a macro and is designed so that you
can change the value in M1 and the value in the other cells will change to
reflect that.

Assuming your pounds are in one column, say column A.

In B1 enter Bob's formula then drag/copy down column B as far as you need.

You would do this for each column of pounds you have, just change the A1 to
another column like C1 or D1


Gord Dibben MS Excel MVP

On Sun, 11 Feb 2007 12:33:00 -0800, Tyn wrote:

Bob,
Sorry I am such a neophyte at this, but I have put 1.818 in M1 and then I do
not know where I go to to write or type in "=A1*$M$1" as you have suggested.
I assume that this is a macro, but dont know how or where to type that
formula in so that I can use it in any cell that I want to calculate the
conversion of british pounds to U.S. dollars.

Would you be able to help me with that, and I also assume, I could type
1.818 into any cell as long as it is not in the way of other cells that I
want to enter numbers in, but it also must be in my worksheet?

Thank you so much for your help and patience with this neophyte.