Results 1 to 3 of 3

Thread: Is there a way to show different currencys i.e "" or "$" depending on the text in a cell?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2014
    Posts
    2,326
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Is there a way to show different currencys i.e "" or "$" depending on the text in a cell?

    Hi Everyone,

    I create invoices in several currencys and I constantly have to change the formating of column J, K, & N which i can sometimes forget.
    however ever company has is currency stated in cell B2 of the sheet.

    so is there an easy way to format the cell to show the correct currancy?
    i.e. if B2= "Dollar" then format "$" "GBP" then format "" ?

    I know I can d it with VBA but was wondering if there was a excel way as I've loads of these to set up.

    any ideas would be apreciated.

    Thanks

    Tony

  2. #2
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    22,645
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Is there a way to show different currencys i.e "" or "$" depending on the text in a cell?

    You could use the TEXT function and a helper column, =TEXT(J1, IF($B$2="dollar","$","")&"#,##0.00")

  3. #3
    Board Regular Kenneth Hobson's Avatar
    Join Date
    Feb 2007
    Location
    Tecumseh, OK
    Posts
    3,079
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Is there a way to show different currencys i.e "" or "$" depending on the text in a cell?

    Hopefully, you are using a currency correction value in your formulas.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •