currency format

  1. M

    Change the Default font for the Currency (and other) number format

    I have the deafult font for my spreadsheets set in File>Options>General to Arial, size 11. Whenever I enter a number it is formatted as Arial size 11. But when use the Number section of the Toolbar to format that number as 'Currency', I get the correct currency symbol (£ in my case), two...
  2. J

    How do I multiply two cells with different cell formats?

    I am trying to do this equation in excel but am not getting the right answer 80:00:00 x $13.66 The 80:00:00=hours worked (calculated from a large formula), the format is [h]:mm:ss $13.66 is the pay (entered straight into the cell it resides in), the format is currency The answer is get is...
  3. C

    How to add dollar signs and commas to the CONCATENATE formula

    I am using the following formulas, but I cannot figure out how to get my result to include a dollar sign and commas to appear as currency. Can someone show me where I need to put edits? =CONCATENATE("You want to make $",ROUND($D$7/($D$8/12),0), " per year?") Currently producing: You want to...
  4. A

    Can I change the formatting of a cell (currency) based on a different cell?

    Is there any way for the display formatting to be changed automatically dependent on whether ISO code I write? <tbody> ALL Lek AFN ؋ ARS $ AWG ƒ AUD $ AZN ₼ BSD $ BBD $ BYR p. BZD BZ$ BMD $ BOB $b BAM KM BWP P BGN лв BRL R$ BND $ KHR ៛ CAD $ KYD $ CLP $...
  5. E

    Help with number formatting on a cell with a number range (formula)

    Hi all, I have a formula which pulls in a number range (e.g. 1000 - 2000) based a lookup, as below: Salary: £15,000 Rating: 3 Recommended increase %: 1-3 (based on Lookup in table) Recommended amount: 150-450 (calculation as 1% and 3% of the salary field). Formula is...
  6. F

    Format currency in column heading

    Hello, In my table I want one of the columns to be titled "Paid" with the sum included. I have this formula, it works fine. When the data changes so does the sum : ="Paid "&SUM(D2:D999) My problem is that it returns a result like this "Paid 377347.65482348". The amount is correct but what I...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top