On 17/04/2008 12:40, Joe Grech wrote:
Is there a way for conversions to Euro without going thru' the wizard then? Cos that was where I was searching!
Yes. As I said in my original e-mail to you the "hack" I explained
applies *only* to the CONVERT *function*. It does *not* apply to the Wizard.
From Calc's Help:
===== begin quote =====
CONVERT
Converts old European national currency to and from Euros.
*Syntax:*
CONVERT(value;"currency1"; "currency2")
*value* is the amount of the currency to be converted.
*currency1* and *currency2* are the currency units to convert from and
to respectively. These must be text, the official abbreviation for the
currency (for example, "EUR"), as shown in the table below. The rates
(shown per Euro) were set by the European Commission.
"EUR"
"ATS"
13.7603
Austrian Schilling
"EUR"
"BEF"
40.3399
Belgian Franc
"EUR"
"DEM"
1.95583
German Mark
"EUR"
"ESP"
166.386
Spanish Peseta
"EUR"
"FIM"
5.94573
Finnish Markka
"EUR"
"FRF"
6.55957
French Franc
"EUR"
"IEP"
0.787564
Irish Pound
"EUR"
"ITL"
1936.27
Italian Lira
"EUR"
"LUF"
40.3399
Luxembourg Franc
"EUR"
"NLG"
2.20371
Dutch Guilder
"EUR"
"PTE"
200.482
Portuguese Escudo
"EUR"
"GRD"
340.750
Greek Drachma
"EUR"
"SIT"
239.640
Slovenian Tolar
Either *currency1* or *currency2* must be specified as Euros.
*Examples:*
=CONVERT(100;"ATS";"EUR") converts 100 Austrian Schillings into Euros.
=CONVERT(100;"EUR";"DEM") converts 100 Euros into German Marks.
=================== end of quote ===============
The hack I sent you adds MTL to the list of currencies this *function*
knows about. It does *not* update the Help, though. And, I repeat, it
does *not* update the Wizard.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
