I have a multi-currency model that allows the user to format using a selection from a number of different currencies e.g. USD, GBP, EUR etc with their relevant currency symbols.
An example of the code within the macro is as follows:
' For USD:
Selection.NumberFormat = _...
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.
I need to have them in Euro format, i.e.
The built in Currency Formatting isn't...
I have w7 installed in English with Spanish keyboard setting. I need this as I operate in both languages. MS Office 2010 is installed in English.
When I right click on a cell to format the currency in € my problems start.
If I want the number to be to 2 decimal places written as 25,00 € (this...
I hope you can offer any help or guidance on the issue I’m currently having.
As an example:
I have a spread sheet which totals the amounts in 2 columns D and E, which are pounds and pence. The formulas for each one are:
I am having a problem where Excel 2007 randomly reformats dates and other numbers as currency. This also happens in pivot tables even though the source data is not currency. Has anyone experienced this before and know the solution?
I am trying to change the currency format of one cell based on the currency format of another cell. So if cell A1 is £5.00 and cell B1 is £10.00 when the format of the master cell (A1) is change to $ then B1 will automatically change to $10.00.
Can anyone help?
I have a graph which does a year on year comparison.
I have added check boxes so users can select/deselect which years are displayed and attached code hides/unhides the relevant source data row which in turn removes/adds it to the graph.
The source data number format is currency with a £...
I have an add-in that imports currency data in a spreadsheet and it reformats cells without decimals!
Is there a way to either use conditional formatting and avoid the circular reference or use even a bit of VB?