currency

Hello, I am an estimator in a company that does installation worldwide. We are quoting in many different currencies, and now have to manually make sure I change the currency in my pricing column every time. To make this easier, I am trying to find a solution: put € or $ or £ or ..., in one...

I have a column where dollar values can be entered. Could range from .01 to 3.00. I need to highlight anything that doesn't end in a 0 or a 5. I thought I could use a RIGHT formula, but it doesn't work as all the 0's are not included in this. Can anyone assist with the correct formula for...

Hi, I need to get real time currency exchange rate EUR/USD. I must use this<code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida...

Hi, I would like to know if this is possible without doing coding. Here's what I want to achieve, I want to have a cell to have a default value i.e. cell B1 to have a default value of "Php0.00" user can type the currency amount on B1 but if the user deleted the entered value it will default...

Re: Currency value on a lable in a userform Hi, I have a user form called "Data_UF" and when I call the user form up it will reflect all employee details on the employee data worksheet. The "Data_UF" user form has textboxes, combo boxes and labels. Cell "T9" has the employee's salary as its...

Hi, I've encountered something, i have a userform with a text box and on every computer on my network it allows for Currency variable to take on the value placed into a text box. Public recSaleCheck As Currency Public machineCheck As Currency 'Puts the value of where the row and column...

Hey, I've got a bunch of data from a BI source, but they havent provided the currency. The values are formatted in the correct currency, so i want to write a formula in another cell that will tell me what currency each line is in. Any idea how i can do this? I'm sure i've done this before but...

Dear Excel friend, I need your help in finding the last value updated along with the cell formatting. I have a table with some country listing in A column and currency amount in the next column The amount columns are formatted on currency as per the country code...

:confused: ok so here i am trying to teach myself some vba ... but its a hard route. i need help making a money counter/ record keeping thingy... i have the userfom basically setup but i am stuck. it doesnt wanna do what i want it to. rather than give a long winded explanation. i will load the...

I have created a budget file with multiple sheets, each sheet has rows by category and columns for each month. The expenses I wish to track can be in one of the following currencies: $, €, ₪, I would like to enter the cost is the currency I have paid at, let's say € so could always know the...

Hello, Every time I make a change within the formula or activate a cell that has a PV, NPV, IRR, etc. function in it, the cell automatically reformats to currency when I press enter. Would anyone know how to turn the auto-formatting feature off? Thank you for your help.

I have this bit of code that creates a subtotal line: 'Add Total row Job Report Dim lastrow2 As Long lastrow2 = Cells(Rows.Count, "I").End(xlUp).Row Cells(lastrow2 + 2, "I").Resize(1, 31) = "=SUBTOTAL(9,I2:I" & lastrow2 & ")" With Range("I" & lastrow2 + 2...

Hi, I need quite a bit of help here as I am new to VBA and XML. I have an Infopath form that basically stores data that users fill in in XML format. Then it will be passed to the Excel to treat the data. There are some data that will be repeated throughout the Infopath form, e.g. Name, Dates...

Hello Add New member here and trying to work with excel. I am sorry if I make mistake the way, I am really new to this. What I am trying to do is: Inter link two order books ( as in an exchange) of two currency pairs; using price and volume. I have tried several times to work out a formula...

Hi everyone, The code here works. But, I can never get the value (displayed in a userform label) to be formatted numerically with commas and 2 decimals (e.g. 1,500.00). I tried every code and placed it everywhere but fails everytime. A simple addition of 1000 + 1500 equals 2001.00. :( I...

Hi all, I am trying to created a UDF for a complicated (to me) calculation. In the function I have Function CalcFee(TxAmount As Currency) As Currency Dim iFeeType As Integer 'FeeType indicates whether a set value £200 or a % iFeeType = WorksheetFunction.VLookup(TxAmount...

I have a spreadsheet with 20+ worksheets. Throughout each sheet there are cells formatted for either "Currency" or "Accounting", depending on how I wanted the cell justified. The cells are currently set to show the USD symbol, but I would like for my users to be able to set the symbol to...

*Hi all, I am trying to do some data validation against some of the fields in an input form. Basically I want to be able to do an IF error for a Vlookup to validate the currency, so if that fails it should say "INVALID", but I also would like a, if the field is blank, "PLEASE ADD ENTRY". This...

Hi all, I have 2 columns A(currencies), B(amounts). I want to auto-color the amount if the certain currency and amount match with the currency and amount in another table. Thank you

Hello! I want to make a currency calculator in Excel but not quite sure how to do it. Basically, I want 2 sheets. The first sheet is where I can calculate the currencies and the second sheet where the data is located. So in the first sheet, I have a drop down for types of currencies (USD, BHD...