Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 05, 11:16 AM
BAZZA
 
Posts: n/a
Default 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

  #2   Report Post  
Old May 20th 05, 01:11 PM
paul
 
Posts: n/a
Default

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

  #3   Report Post  
Old May 20th 05, 01:15 PM
Bob Phillips
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DIFFERENT CURRENCY FORMATS IN FORMULA BAZZA Excel Worksheet Functions 3 May 19th 05 12:28 PM


All times are GMT +1. The time now is 11:46 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017