Ms-Query Eur Symbol

[CB]

HELP !!

I have a file reading a table on as400 using odbc. In one field we have
some words, numbers and then Eur Symbol €
If I open Microsoft Query I see correctly the content while if I return
data to excel and I look directly on the excel sheet I see a strange
char (like a square) instead of €.
Any idea?? I'm loosing my mind on this problem!!

Thanks a lot

Claudia

 

[CB]

Really noone can help me?!?!?!?!?!?!!?!?

Cla
CB ha scritto:

 

[Roger Govier]

Hi

The Euro symbol is Code(128) on my machine.
Test to se what code is being returned by the character in the position
where you are seeing square.

Maybe you could do a Substitute(A1,Char(128),Char(your_Value)

--
Regards

Roger Govier


Really noone can help me?!?!?!?!?!?!!?!?

Cla
CB ha scritto:

 

[Mike Woodhouse]

HELP !!

I have a file reading a table on as400 using odbc. In one field we have
some words, numbers and then Eur Symbol €
If I open Microsoft Query I see correctly the content while if I return
data to excel and I look directly on the excel sheet I see a strange
char (like a square) instead of €.
Any idea?? I'm loosing my mind on this problem!!

The square is usually represents a character that the used font doesn't
include. What font are you using?

Try changing the font in your worksheet to (say) Arial, which on my PC
at least, displays a €.

If you believe the font should displays Euro symbols correctly, try
putting =CHAR(128) into a cell: the Euro symbol should be displayed. If
not, come back here...

Mike

 

[JLGWhiz]

The Euro currency symbol is available as an insert from the menu bar
Insert>Symbol and select from the symbol chart. If you need to use it
consistently you might need to change the regional settings in Control Panel
to get European characters automatically.

 

[Mike Woodhouse]

The Euro currency symbol is available as an insert from the menu bar
Insert>Symbol and select from the symbol chart. If you need to use it
consistently you might need to change the regional settings in Control Panel
to get European characters automatically.

Keyboards in at least some regions* (mine here in the UK is one) can
produce the Euro symbol using Alt Gr+4. Which means I finally have a
use for the Alt Gr key after all these years.

Mike

* I haven't looked at enough keyboards in enough countries to have any
idea how widely this is available!

 

[NickHK]

Mike,
What do you mean by "Alt Gr" ?

NickHK

Keyboards in at least some regions* (mine here in the UK is one) can
produce the Euro symbol using Alt Gr+4. Which means I finally have a
use for the Alt Gr key after all these years.

Mike

* I haven't looked at enough keyboards in enough countries to have any
idea how widely this is available!

 

[Roger Govier]

Hi Nick

What do you mean by "Alt Gr" ?

The second Alt button, located to the right of the space bar.
It is for Alternative Graphics and is used to access the third character
engraved on some keys.
On my UK keyboard, the Euro symbol is shown at the bottom right of the
number 4 key and holding Alt-Gr and pressing 4 produces € or Alt-Gr and
the key to the left of 1 produces the pipe character ¦