Alphaquark author's Note :
This page is a translation of
Euro
with the help of
Altavista translation.
I hope this translation is good, but if there are any errors, you can
write me.
If this translation is successful, perhaps I will try to translate another document of
Alphaquark.

Once the patch installed, the symbol euro has the ASCII code 128.
Windows (and software) is in general configured for to obtain the symbol with the keys alt gr + E.

The symbol is correctly displayed but not inevitably printed ; Why ?
In order to optimize the printing, the software under Windows send at the printer the ASCII
codes characters but not their pictures.
The internal fonts of the printer are used. Result, the ASCII code 128 (lately allotted to the
symbol euro) corresponds at another character on the printer. For that, it is thus necessary to
carry out this handling :

That obliges Windows to send at the printer the image of each character and not the code ASCII.
The counterpart is that the impression is slower.

Use of the character euro

Whatever the software used, we normally obtains the
character with the keys alt gr. E.

Excel

We must to have a column reserved for the values in Euro. Thus let
us select the column or the cells concerned.

Then by small "the format, cell", page "number",
category "personalized", select the following format :

# ## 0,00\ " ";
- # ## 0,00\ " "

We have to the monetary formats running but by
using it .

By putting a value in one of these cells, there will be
for example 1 234,12 .

Access

In the page table, to open the table containing the field
devoted to the values in euro.

To put itself in creation mode (menu "display, creation").

To select the field devoted to the values in euro.

To put the size of the field in simple real (or double).

To put the format :

# ## 0,00\ " ";
- # ## 0,00\ " "

The number of decimal must be to 2 (the monetary format containing only the centimes).

To close again the table by recording it obviously.

Use without the character euro

At the installation of the character, with certain type of printer, there isn't the page font
tab". See the installation and configuration of the euro.
The result is that the character
is correctly displayed
with the screen but isn't printed.

As one inevitably will not buy a new printer only for the symbol
, then here some tips.

Word

The tip consists in using the field equation which makes
it possible to superimpose two characters. Here one will superimpose
the equal sign (=) and the letter C capital letter.

Procedure:

Menu "Insertion, field".
Category "Equations and formulas".
Field eq.
To take the option \o.

The generated field is thus { EQ \O(=; C) }. Result:

Should well be paid attention to put space before C If
not C would be to stick too on the left on the equal sign.

Excel

For all the cells which must be with the monetary format
Euro, to simulate the format euro it is necessary to put this mask :

# ## 0,00\ " E"; - # ## 0,00\ " E"

For 1 500,34 euros, that will display :

1 500,34 E

Access

The principle is the same one as for the use with the symbol
with the difference close will put it the following format :

# ## 0,00\ " E";-# ## 0,00\ " E"

Downloading of the Euro symbol

To have the character
with the impression when one does not have the possibility of having the option "To print
truetype as graphs" (see the installation and configuration),
there is nevertheless an tip. It is enough to create a express font for this character
, this font not being used
by the printers, the image of the character (and not its code ASCII) will be sent to the printer.

I thus come, with Corel Draw 6 to create this named font
Alphasymb and I propose to you to download it. Good, I benefitted
from it to include some other symbols. This font is free and free of
right.

Download
the symbol euro and its construction. The file euro.zip (45 KB) contains the
files according to :

file :

description:

Euro_construction.cdr

construction of the symbol to the format Corel Draw 6

Euro.ai

symbol with the format postscript Illustrator Adobe

Euro.wmf

symbol with the format Metafile Windows

Euro_construction.ai

construction with the format postscript Illustrator Adobe

Euro_construction.wmf

construction with the format Metafile Windows

Alphasymb.ttf

organizes truetype comprising the Euro symbol

For other formats (gif, jpeg, tiff, bmp...), contact
Thibaut.
If format bitmap, specify the size in pixel and the colors desired.

The Alphasymb font comprising the character
obviously,
but also some other symbols:

If you have other ideas of reasons, don't hesitate with me to subject
them.
Why not a font of symbols with smiley or other ?

Installation and use of the Alphasymb font

Under Windows :

Icon "My computer"
Icon "Control panel"
Icon "Fonts"
Menu "To install the new font"
And to follow as usual the instructions, think of the folder where you extract the file
euro.zip.

On the level codes ASCII, the symbols are mainly placed on the letters. It is thus enough to
type for example the E capital letter and to put it in the Alphasymb font.

Word

Selection of the symbols :

Menu "Insertion", "Characters special"
Organizes alphasymb

One can benefit from it to allot to the symbols a combination
keys (button "Shortcut keys"); Example : alt gr E.

Excel

Several possibilities are offered to us.

1) To type a value and the letter E Exemple: 1 500,34 E
Then to select the E to be put in Alphasymb.
The advantage is that one has the number in the desired font
and our symbol .
The problem is that one finds oneself with a character string
and not the numerical value 1 500,34. That would oblige us to juggle
with the formulas of conversion text to numerical to make calculations
on the values.

2) To put only the value in a cell (with like masks display # ## 0,00; - # ## 0,00),
and to devote the adjacent cell to the only character
.
The advantage are: one has our
and the value in the
desired font, and the possibility of putting formulas instead of a value.
The disadvantage is that one has two cells to recopy (the value is that of
).

3) To put only the value in a cell (with like masks display
# ## 0,00 \ " E"; - # ## 0,00 \ " E"),
to select the cell to be put in Alphasymb.
The advantage is that one has that a cell to be recopied (case interesting of a formula to be
recopied for conversions into euro for example).
The disadvantage is that in our Alphasymb font, the figures are characters stick (as the arial).
Therefore not of choice of fonts for the number. If not it would be necessary to create as many
fonts than necessary; it would also be necessary to take account of the attributes like the italic
and the fat. What would quite simply complicate the situation for the character
.

Access

But what interesting here is to use the Alphasymb font in a state.

Symbol

For that, once that the state is created, it is necessary to put
(with with dimensions field devoted to the values in euro) a
heading comprising the letter E capital letter.
Using the properties, to put this heading organizes Alphasymb of it.
It will be necessary that this heading is preferably of the same size of character as the field
adequate; If not one will be able obviously to choose his color and the other attributes (fatty,
Italic, etc).

Field containing the value in euro

It is necessary to put format # ##0,00;-# ##0,00

With the impression there will be our symbol
with dimensioned value
(12,50 for example).

On the other hand, for the impression direct of the tables, I acknowledge that I did not find
the trick for mixer several character fonts in a cell (as in Excel). It is thus necessary in the
table to use the format (as indicated in the use
part without the Euro character) :

# ##0,00\ " E";-# ##0,00\ " E"

Conversion Franc at Euro

Note of the author of Alphaquark :
The original page (Euro)
was created for the french. It's why we speak here of the conversion Franc at Euro.
But for another money, the main thing is the same for a conversion in another money.
You must just to inquire about the value of conversion (example 6,55957 for the Franc at
Euro).

For conversion euro in Franc, the principle is the same one with the difference that one
multiplies (instead of dividing) by 6,55957.

Excel

The formula is :

=Arrondi(A1/6,55957;2)

It is supposed here that our value in Franc is in A1. One thus divides by our constant 6,55957
that one rounded with two decimals.

Access

In a table, that we will name Testeuro for the example, there is a field in franc. But with the
passing of years one accumulated hundreds (see thousands) of values in franc. One wants to see,
as an indication what that goes given in euro. Here the request :

Function CCur converted a reality into money value but with 4 decimals ;
Whereas what interests us is to have the value with 2 decimals.
It is thus necessary to divide the value converted CCur(FRANC/6.55957) by 100 to reconvert
it in money value CCur(CCur(franc/6.55957)/100). There are always four decimals, but the
tip consists of the division by 100 which obliges to lose the two last decimals.
By converting it into a real number and multiplying it the result by 100, one obtains a
real number with two decimals.

Concerning the display and the impression, to refer to the preceding chapters.