different currencies
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 |
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..... -- paul remove nospam for email addy! ) "BAZZA" wrote: 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 |
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) "BAZZA" wrote in message ... 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 |
All times are GMT +1. The time now is 06:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com