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

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

Cla
CB ha scritto:

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

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


"CB" wrote in message
ups.com...
Really noone can help me?!?!?!?!?!?!!?!?

Cla
CB ha scritto:

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

On Nov 20, 9:48 am, "CB" wrote:
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

The Euro currency symbol is available as an insert from the menu bar
InsertSymbol 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.

"CB" wrote:

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

On Nov 20, 6:12 pm, JLGWhiz wrote:
The Euro currency symbol is available as an insert from the menu bar
InsertSymbol 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!

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

NickHK

"Mike Woodhouse" wrote in message
ups.com...


On Nov 20, 6:12 pm, JLGWhiz wrote:
The Euro currency symbol is available as an insert from the menu bar
InsertSymbol 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!

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 ¦

--
Regards

Roger Govier


"NickHK" wrote in message
...
Mike,
What do you mean by "Alt Gr" ?

NickHK

"Mike Woodhouse" wrote in message
ups.com...


On Nov 20, 6:12 pm, JLGWhiz
wrote:
The Euro currency symbol is available as an insert from the menu
bar
InsertSymbol 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!