currency conversion

  1. D

    Convert text to number for currency

    I need to write a macro for converting text to number. I have tried recording when I do text to columns but when I tried to run the macro under the same conditions as when it was recorded then it doesn't wok and the numbers stay as text. What do I need to do to make the text convert to a number?
  2. M

    VBA to find and change currency values in workbook

    I have a workbook where I'd like to change the currencies between USD & Euro (and back again) easily. I have a code (below) to change the format, from $ to € however, it doesn't change the value. Changing $100 to €100 is wrong as the initial value should take into account an exchange rate. So...
  3. I

    Lookup, match, change cells, then multiply across tabs VBA

    okay i just started using VBA/macros today and im pretty pleased with my progress so far :) but hit a brick wall i think above my pay grade... not looking for a bailout i'd like to understand this for the future. My job could really use these.... Data tab called "Quotation Tool": <tbody>...
  4. D

    Multiple MATCH within INDEX function

    Hello, I need to pull various exchange rates that are located in a separate worksheet (FX Table), and which must correspond to a) a certain date and b) a certain currency. The formula below seem to only account for the date, and omits the currency ticker. D18 is the date G3 is the currency Row...
  5. U

    Currency Conversion in PowerPivot (FX, Oanda)

    I have a table containing sales, which has 4 columns; date, item name, currency, price. We sell in multiple currencies and the price in this table is the currency of the sale. So, in this table we have EUR, GBP, USD, SKK, NOK, DKK, etc. I would like to create a fifth column in my sales table...
  6. B

    "#####" Return when formatting column sum to Currency

    Hopefully someone can help (I am relatively new to Excel) I need the sums of my columns to be formatted into currency, the problem is, after clicking the format into currency button, all the sums change into #######. Am I doing something wrong ? This is the formula I used =SUM(H3:H352).
  7. F

    Currency Conversions

    I have a list of different products and their prices, which are in multiple currencies. I want to create a pivot table that will show these products with the prices all converted to a chosen reporting currency based on the conversion table. I've pasted a mock-up below, can anyone help with how...
  8. R

    Using VBA sheet code to perform large scale currency conversion

    Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Wondering if you can help. I have a workbook with 6 different worksheets each containing a report in Excel 2007. All values in the worksheets are in $USD.<o:p></o:p> <o:p></o:p> I would...

Some videos you may like

This Week's Hot Topics