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.
--
Thank You,
Tyn


"Bob Phillips" wrote:

Put 1.818 in a cell, say M1, and then use

=A1*$M$1

and copy down.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Tyn" wrote in message
...
I just started using MS Excel 2003 and am trying to make a spread sheet
which
is for an company expense sheet...and I want to be able to multiply many
of
the cells by constant number of US Dollars per British Pounds (1.818
dollars
per Pound), so that I can covert the number of pounds my employes have
spent,
into dollars.

Can anyone help me, it sounds easy, but I dont know how to use or create
macros yet. I have used the function button to add, subtract, multiply
and
divide values in single cells.
--
Thank You,
Tyn