currency 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...

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...

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...

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 $...

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...

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...