euro

Hi All. I have just been sorting out an excel file for the warehouse locations for pallet spaces. What I was trying to do was if a was in a space I could either use an EU for euro pallet or UK for a UK pallet which are bigger than the Euro pallet it would turn Red to say there was a pallet there...

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

Hi all, Hopefully it's possible, what not in excel :) I'm familiar with the large function, the thing is that I would like to make it dynamic with a vlookup or match function in it. So in the below case if a user wants to find out the highest sales of the three weeks by a certain product, he...

Hi everyone, Hopefully a simple one for someone but I cannot get it to work! I’m trying to convert all currencies on a spreadsheet to USD Column B has the base price, Column C has either (GBP,USD,EUR). What I am wishing to do is in column D show a USD price only , so if column C says GBP or...

I've noticed that when I type ALT 128 (the Euro symbol) into a cell in front of a number I get the following number format (I have the cell formatted as General when I'm inserting this currency symbol): [$€-x-euro2] #,##0;[Red]-[$€-x-euro2] #,##0 I can type Alt 36 (the USD currency...

Can someone please assist.... I am trying to generate a formula where I place a figure amount for example the EURO conversion of the australian dollar to euro being 61 cents in the euro, I would like it then when I make that change to that figure of 61 to lets say 62 it automatically changes...

Hello, I have a data set that ends with Euro symbol sign. For exambple 2,353.00 € These symbols are in both horizontal and vertical cells. Because the data looks quite complex. Is there a way to give the Euro symbol a different color (red) The cells are formatted as Euro Currency with...

Hi guys, i've got a problem with a scraping of a table from a website. Unfortunally i don't have an id to locate in a second the table in the web page, but this is located in another table that i can identify. I can post the html code here below : < table id="addreg" class="display...

Hi All, I have values in column L such as the following: 400,000 300,300 1,230,340 I want to group these into certain bands within Column M, the band are listed within a separate tab called "Bands" and the options are as follows - how can I code this? I fear the word "Euro" could cause...

Dear all, I want to do the following. Highlight the cell in column G and H if the total value of the cell in column G and H is not the same as the value written in the corresponding cell in column E. So for example: G1 (100 euro) and H1 (2900 euro) together are 3000 euro, but the cell E1 is...

Hi Sorry if this has long since been discussed and solved, but sadly in searching this and other forums and the web, I can't find a solution! doh! Must be blind? I guess the fact I'm in the UK might be relevant to code pages etc. I'm reading in (well cut and pasting from a text file that is...

Excel 2010 Using Windows Operating System Hi, I'm an America trying to convert the values I have in 1 spreadsheet to a European number format. The American format seperates thousands with "," and decimals with ".". The European system is the opposite seperating thousand figures with a "."...