• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to show Currency symbol in column 'Amount", which is based on a currency code?

I

inddon

Member
Hello There,

I have the following master data:

Currency Code....Symbol
---------------------------
EUR.....................€
USD.....................$
GBP.....................£

and the below data entry columns for amount as follows (all are input cells by the user).
When I enter EUR in 'Invoice Currency' column and enter an amount in 'Invoice Amount', it should automatically have the respective symbol of the entered currency in the 'Invoice Amount' as below:

Invoice.......Invoice........Order
Currency....Amount.......Amount
-----------------------------------
EUR............€1000............€1000
USD............$5500............$5500

This will be applicable across the Invoice and Order Amount columns.


Could you please advice and help me out.

Thank you & regards
Don
 
Hi Don,

You could use Conditional Formatting to do this.

Select the Invoice Amount & Order Amount columns and add the following conditional formats

For USD: =$A2="USD" format as dollars
For GBP : =$A2="GBP" format as pounds
For EUR : =$A2="EUR" format as euros

I have attached a sample file. Please check the conditional formatting applied on columns B & C.

Regards!!!
 

Attachments

Last edited:
Hi inddon,

You can simply change the format of your cell by pressing Ctrl+1
Under the Number Tab go to Currency and select the required currency..

You can also use conditional formatting
Suppose your B2 = USD
and invoice amounts in C2 and D2
Select C2 and D2 > write formula in CF
=$B$2="USD"
Then click format > change the number format to $

Same procedure for other currencies...
Regards,
Khalid.
 
Thank You AIM and Khalid for your quick reply.

Both your solution works.

When you copy the cell across multiple cells within the column then AIM's solution works goes a bit further.

Regards
Don
 
You must log in or register to reply here.
Back
Top