different currencies

B

BAZZA

i have three columns
column a date
column b product
coulmn c amount
I want to enter an amount in coulmn c e.g. 5-00 against product for say book
from column b and I would like it to appear as USD $5-00. I know I can go to
format currency and symbol for this entry but on the next line I want to
enter another product say marker and the amount 2-00 but it may be in Euro
Currency and I do not want to go to format/currency/symbol on each entry.
Is there a formula I could enter that wouyld automatically enter the
currency symbol and text e.g.USD $,EURO €,AUD $,GBP £, NZD $,CAD $.
I have enetred a vlookup table in sheet for product and currency but when i
enter the amount it knocks out the formula.
I cannot use conditional formatting as it is a shared worksheet.
Hope you can help.
Thank you
 
P

paul

type a column of your currencies in a column immediately above the column you
want to show the currency(it works best if the currency is in its own
column).Whenever you type say N for NZ$ the NZ$ will pop up automatically!You
can hide the rows you have your list.....
 
B

Bob Phillips

Why don't you use the VLOOKUP to put the currency in a separate column to
the amount?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top