# currency

1. ### Formula to convert currency cost into a percentage

Hello, Which is the correct way/formula to convert the currency cost into a formula. For example: \$39.21 shows as 3921% - May I know which formula I should use to get the percentage in a correct way. These are the sub-totals cost I have and I would like to show them in a percentage form...

Hi, I have a code for listbox with textboxes. how can I format the box to \$ currency by adding this line of code to each box that has dollar amount, I would like to add this line of code: " & Format(Range("E").Value, "\$#,##0.00;(\$#,##0.00)") to this code: (Bold and red colour) Private Sub...
3. ### Change format of userform textbox to currency

Hi there, I have a userform with 4 textboxes that when text is entered they all refer back to individual cells. All data entered on a spreadsheet goes to the userform and when entered into the userform goes back to the spreadsheet. One of the textboxes displays a price but i cant seem to change...
4. ### Format cell with currency informed in other cell using a single formula

HI, I cell B1 I have a drop down list to select the currencies that are written in the ISO currency code (EUR, USD,....) cell C1 I have the qty Cell D1 the unit value Cell E1 is C1*D1 I am looking for a formula to format the cell E1 as currency using the currency informed in B1 I have...
5. ### Converting UK Currency to Euro format

Hello I posted this yesterday but I think it was in the wrong place. Sorry. I have a worksheet where all the values are written in UK format, e.g. 10,000,000.00 7,500.12 100.00 I need to have them in Euro format, i.e. 10.000.000,00 7.500,12 100,00 The built in Currency Formatting isn't...
6. ### Automatic conversion of the currency

Hello! I have a table to be filled in with the prices of some products from different offers. Some products are acquired in the Euro currency and the others in the RON currency. My question is if is any possibility (macros, formulas) so that when I insert the value expressed in one currency...
7. ### (3) Dropdown list to equal \$

Greetings, is it possible to have (3) dropdown lists equal a dollar amount? Task at Hand: I will try to simplify to help make sense. Let's use a restaurant menu as an example. Depending on your order and the options chosen, the total will be different. Dropdown list 1: Types of meat-Chicken or...
8. ### Analyze workbook calculation time

Hi, I developed this tool analyze my workbook to identify which formula is too slow. This code works and I tested many times. But I don't have much low level knowledge of Excel in general. So can someone look at the code and tell me what's the limitation(s) of this code? Private Declare...
9. ### VBA Currency Conversion Function (Historical Date)

I have been looking around the internet with no success for a VBA function which will simply take 3 arguments: Currency From, Currency To, Date and output the relevant FX Rate. Has anyone worked with a successful solution? I am currently using this procedure which works fast but it outputs a...
10. ### convert currency from numbers to words

hello, i want to convert the rupees from numric to words. how can we do that?
11. ### Vba concatenate 2 columns that have a currency

Hi all, Any advice would be appreciated on this! Column P of my workbook is a numerical column and Column Q is a Currency sign indicator, I need to add the Currency sign indicator to the front of the cell in column P or at the end depending on the currency sign indicator. £ = UK Pounds P =...
12. ### Divide columns x/y iF purchase in table

I have a formatted table with a transaction type, a transaction fee in USD, and a rate USD of a certain currency (x). How do I find the rate of transaction of currency X, only when transaction type Y is occurring? I have two different transaction types, purchases and transfers. Transfers have a...
13. ### Excel 2016 TEXT function ignores formatting

Hello, everyone, I have a pivot table displaying the total sales of three brands in two columns (one as currency, the other as % of total). The currency column's numbers are formatted as currency, with thousands separator, two decimal places and "лв." after each number. For each of the three...
14. ### Add 5% to an existing formula

Hi Have this formula: =(K12+V12)*F12 K12 is a product cost V12 is a ancillary product cost F12 is the exchange rate from \$ to £ I want to add a 5% currency fluctuation surcharge into the calculation , I have 5% written in cell G12 Is there a way I can add to the formula the 5% to the 2...
15. ### Using vlookup for multiplication

Ok two I have two files File 1 Column A Column B Currency FX Rate USD 1.14 EUR 1 JPY 126.77 File 2 Column F Column G Column K Local Currency Local...
16. ### Add a formula after cell text content

I have a Wages worksheet. I have a Pay amount (manually entered, Currency format, no decimal places) and a Tax amount (manually entered, Currency format, two decimal places). An an example, the Pay cell contains "£1000" and the Tax cell contains "£100". Is it possible to make the Tax cell...
17. ### Currency List

Excel 2016. Hello Excellers. Here is the 'stupid question du jour'... is there any way to loop through the list of currency options using VBA? I'm referring to the options when you format a cell, click currency and then you get a long list of options (currency symbol and region). I'm wanting to...
18. ### Cost Value Calculator

<tbody> Cost value (Local currency) Currency Cost value 500 SGD 3664 EUR </tbody> So I'm stuck in a situation whereby, I'm supposed to convert the cost value (local currency) into cost (in USD). I had made a button to run the VBA Macro to calculate the values and paste back into the...
19. ### Convert Text Field to Currency

Can anybody advise how I can convert what seems to be a text field into a currency field? I have a report which I have exported from a website but whatever I do I cannot convert this field into anything that I can subsequently use to run calculations on? Can anybody help? Thanks
20. ### Formatting Currency in VLOOKUP formula

I have this formula and I am trying to get the currency part that is pulled from another sheet to populate as currency in the VLOOKUP formula. What am I missing? =("Your purchase donated \$"&IFERROR(VLOOKUP(rngInvoice,InvoicesMain,9,FALSE),"")&" to Alex's Lemonade Stand") This exact formula...