Hi,
I need to create an Excel pricing sheet that prices in different languages. I have a cell where the user picks a few languages, i.e. Pound sterling, US, Euro, etc. Is there a way based on the language they pick in the calculator that I can display the symbol of the prices, i.e. £, $, €... nex to the number pricing?
Thank you for your help.
You can do this with conditional formatting.
What cell contains the currency type and what cell will the price be in?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try using conditional formatting the prices (using financial format) based on the content of the currency cell.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
This will only change the symbol not the value, you will also need to create a list of exchange rates so that changing currency will also convert to the correct amount (if that's something you need).
Say thanks, click *
Thank you Tsjallie that is exactly what I needed.
Best regards,
chitownbill
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks