Adding a currency symbol prefix to a cell in Excel

Discussion in 'Mac Apps and Mac App Store' started by jent, Oct 1, 2011.

  1. jent macrumors 6502a

    jent

    Joined:
    Mar 31, 2010
    #1
    Instead of using the built-in Excel options for currency, I'd like to create a custom symbol for a currency. For some currencies, Excel uses the actual symbol itself, such as $, €, ¥, et cetera. For others, it uses the three-digit currency code, which is not a symbol itself.

    For example, BOB is the currency code for Bolivian bolivianos, so Excel would display it as 100 BOB if I chose the bolivianos option. In this example, I'd like to create a custom prefix that adds "Bs." to the beginning of the number in the cell, while still treating it like a number, so I can use formulas to add multiple cells and total my spending, as well as convert said total into USD.

    I can't seem to figure out how, as my best guess in Format --> Format Cells… --> Number --> Custom gives me an error, which I'm attaching as a screenshot. Thanks for any help!
     

    Attached Files:

  2. cdte92 macrumors newbie

    Joined:
    Jul 20, 2010
    Location:
    Kirkcaldy, Scotland
    #2
    try this

    "Bs."_0.00 seems to work in the custom format field - in excel 2011
     
  3. jent thread starter macrumors 6502a

    jent

    Joined:
    Mar 31, 2010
    #3
    That works great. Thank you!
     

Share This Page