Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm back on my old favourite again, the wonderful cost estimate
spreadsheet. This time i've been asked to give it an "International capability". What this means is I have a table of countries that we might produce estimates for, containing rates for each country for anual salary rate, RPI %, Local tax (VAT/Purchase tax), DASD, Tape, Network and Memory rates. That little lot isn't too much of a problem to incorporate into the calculations. Where i'm having problems is that the resulting figures/totals are required to be displayed using the Currency symbol (also in the table) for the country the estimate is being produced for, i=2Ee. USA =3D $, UK =3D =A3, Euro Region =3D =80 etc. etc. etc ........ currently up to 12 different currencies and liable to grow. Can anyone me a suggestion/solution as to how to achieve the seemingly impossible please ? Thanks and Regards Fred Newton Zurich Financial Services |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
im trying to change the default currency for my excel from $ to M. | Excel Discussion (Misc queries) | |||
How do I change the highlight color of selected menu items? | Excel Discussion (Misc queries) | |||
The currency symbol on all my spreadsheets has changed from £ to . | Excel Discussion (Misc queries) |