It's not a bother, but an intriguing challenge of the type that some of us
thrive on
However, I am still not clear on whether you want the table to
make the conversion from Sterling to Euros, and if you do what you are going
to use as an exchange rate, which as you know goes up and down like a
bride's nightie.
If you are creating invoices for British and European clients, then it
shouldn't be too difficult to use to ensure that you have the right prices
on your documents. It's a little more difficult if you want to only have the
right currency and the correct value of that currency shown, but it is not
impossible.
If you use an ASK field for the exchange rate
eg { Ask Rate "Exchange Rate" \d "1.3056448789"}
then
{ ={ =SUM(LEFT) } * { Rate } \# "EUR ,0.00"}
in the cell to the right of the GBP total will give you the Euro amount
(assuming there are no other amounts on that row).
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Lotiana wrote:
Graham, it's about the very unsophisticated invoices I send from the
UK to our clients on the Continental Europe - a small table I'd like
to keep Word-only.
So far, I "compromised": one column displays GBP 1,000.00, the
corresponding one EUR 1,600.00 (with number format {=SUM(ABOVE) \#
"EUR #,##0.00"}).
With so many beautiful functions/features of Word, I would have
thought that the other format may co-exist too (like a column with
formulas with the other number format, displaying EUR 1.600,00 with,
say, {=SUM(ABOVE) \# "EUR #.##0,00"}).
Sorry for bothering you, Graham, I don't want to waste your time; not
bad if not possible: clients got used to it anyway (otherwise I'd had
used Excel); I just wanted to imitate instantly the double display in
Amazon.co.uk's invoices, and to write to a supplier from the
Continent a letter with a calculation without changing first Regional
settings in Control Panel. But I'm only doing this sort of work
rarely, it's not among my main tasks.
"Graham Mayor" wrote:
How is Word to know whether the number is GBP or EUR?
Are the relative values of the currencies relevant?
We need more information about exactly what you are trying to
achieve.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Lotiana wrote:
How can I get in the same table both GBP 9,999.99 and EUR 9.999,99 ?
"Regional settings" either/or don't help!