What is the function to return the code associated with a unicode symbol? If
I enter ALT-1234 in cell (say A1), I get a pi-type symbol:

•¥

However CODE(A1) returns a 63. How can I get the 1234 back?
--
Gary''s Student

is that as shown at:

http://tinyurl.com/onnk2

?

--

Gary''s Student Wrote:
What is the function to return the code associated with a unicode
symbol? If
I enter ALT-1234 in cell (say A1), I get a pi-type symbol:

•¥

However CODE(A1) returns a 63. How can I get the 1234 back?
--
Gary''s Student


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532566

Just a point of reference, in my Excel97, SR2......when I type Alt-1234 in
A1, A1 displays the Pi symbol, and =CODE(A1) shows 45. If I type in
Alt-045, the cell displays a hyphen. If I type in a hyphen, =CODE(A1) shows
45 again........also, Chip's CodeView Add-in follows suite.

Vaya con Dios,
Chuck, CABGx3



"Gary''s Student" wrote:

What is the function to return the code associated with a unicode symbol? If
I enter ALT-1234 in cell (say A1), I get a pi-type symbol:

•¥

However CODE(A1) returns a 63. How can I get the 1234 back?
--
Gary''s Student

Hi,

Can I ask which Font you are using, as I need Alt-112 (or Alt-0112)
with the Symbol font to produce a Pi symbol. (Windows XP, Office 2003)

I use the attached sheet (Chars, is like Charmap with addresses) to
determine which characters will be displayed for the relavant Alt-code
for the currently selected Font, and note that where a 4 digit code
Alt-0nnn to Alt-0255 is entered the chacters from rows 17 to 29 of
worksheet Chars are displayed, whereas if Alt-nnn to Alt-255, or a
calculated figure are used then characters from rows 3 to 15 are
displayed.

The 'calculated figure' - it seems that for any Alt-entry not in the
Alt-0 to Alt-256 or Alt-0000 to Alt-0256 ranges that the character
displayed is the Mod of the entered code divided by 256 (or
thereabouts). I did a partial construction of numbers Alt-1000+ and
Alt-2000+, and these seem to follow the plan.

If this is correct, then the '1' is your Alt-1234 cannot be returned as
it is not (as I had previously thought) a 'code', but is just a part of
a 'to big' code that is trimmed to the 0-255 range.

If anyone has a better understanding of the Alt-code system I would
welcome a better explanation, however to Gary''s Student's original
question, I have no method to determine whether the character was the
result of an Alt-0nnn or 'other' entry, ie, whether the display came
from rows 3-15 or 17-29.

Bryan

Attachment is:
http://www.excelforum.com/attachment...4&d=1145115775

CLR Wrote:
Just a point of reference, in my Excel97, SR2......when I type Alt-1234
in
A1, A1 displays the Pi symbol, and =CODE(A1) shows 45. If I type in
Alt-045, the cell displays a hyphen. If I type in a hyphen, =CODE(A1)
shows
45 again........also, Chip's CodeView Add-in follows suite.

Vaya con Dios,
Chuck, CABGx3



"Gary''s Student" wrote:

What is the function to return the code associated with a unicode
symbol? If
I enter ALT-1234 in cell (say A1), I get a pi-type symbol:

â•¥

However CODE(A1) returns a 63. How can I get the 1234 back?
--
Gary''s Student


+-------------------------------------------------------------------+
|Filename: Chars2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4634 |
+-------------------------------------------------------------------+

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532566

The font on both my office machine XL97/SR2 and this home machine XL97/SR1
is the standard Ariel. As I said, at work if I enter Alt-1234 I get the Pi
symbol with CODE() reading 45, but, here at home by typing in Alt-1234 I get
just a hyphen with CODE() reading 45..........also on this machine I have
XL2k and it returns the hyphen and CODE() 45 also.........I have no clue to
the mechanics of it all, just reporting what I've seen.....

Vaya con Dios,
Chuck, CABGx3

..




"Bryan Hessey"
wrote in message
news:Bryan.Hessey.26bc5z_1145116802.3261@excelforu m-nospam.com...

Hi,

Can I ask which Font you are using, as I need Alt-112 (or Alt-0112)
with the Symbol font to produce a Pi symbol. (Windows XP, Office 2003)

I use the attached sheet (Chars, is like Charmap with addresses) to
determine which characters will be displayed for the relavant Alt-code
for the currently selected Font, and note that where a 4 digit code
Alt-0nnn to Alt-0255 is entered the chacters from rows 17 to 29 of
worksheet Chars are displayed, whereas if Alt-nnn to Alt-255, or a
calculated figure are used then characters from rows 3 to 15 are
displayed.

The 'calculated figure' - it seems that for any Alt-entry not in the
Alt-0 to Alt-256 or Alt-0000 to Alt-0256 ranges that the character
displayed is the Mod of the entered code divided by 256 (or
thereabouts). I did a partial construction of numbers Alt-1000+ and
Alt-2000+, and these seem to follow the plan.

If this is correct, then the '1' is your Alt-1234 cannot be returned as
it is not (as I had previously thought) a 'code', but is just a part of
a 'to big' code that is trimmed to the 0-255 range.

If anyone has a better understanding of the Alt-code system I would
welcome a better explanation, however to Gary''s Student's original
question, I have no method to determine whether the character was the
result of an Alt-0nnn or 'other' entry, ie, whether the display came
from rows 3-15 or 17-29.

Bryan

Attachment is:
http://www.excelforum.com/attachment...4&d=1145115775

CLR Wrote:
Just a point of reference, in my Excel97, SR2......when I type Alt-1234
in
A1, A1 displays the Pi symbol, and =CODE(A1) shows 45. If I type in
Alt-045, the cell displays a hyphen. If I type in a hyphen, =CODE(A1)
shows
45 again........also, Chip's CodeView Add-in follows suite.

Vaya con Dios,
Chuck, CABGx3



"Gary''s Student" wrote:

What is the function to return the code associated with a unicode
symbol? If
I enter ALT-1234 in cell (say A1), I get a pi-type symbol:

â•¥

However CODE(A1) returns a 63. How can I get the 1234 back?
--
Gary''s Student


+-------------------------------------------------------------------+
|Filename: Chars2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4634 |
+-------------------------------------------------------------------+

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532566

CLR,

I too run standard Arial, which displays my 'lack of' here because I
simply cannot see a Pi symbol on characters Alt-0 to Alt-1255, the
attached Word document shows a screen capture of the Alt-1000 to
Alt-1255, which are the same characters as displayed in Alt-0 to
Alt-255 range offset by 1024

(I used the screen capture so that different systems fonts would not
affect the view)

In a DOS window, the CHCP command confirms my codepage is 850, I also
tried 437 and 852 but the Alt-1234 remained as a E+tilde character.

If you loaded my Chars2.wks, could you please select the Chars sheet,
select the fonttest range, and select Arial as the font (it was set to
Symbol to locate a Pi symbol) and confirm what character is displayed
at K13

Thanks

Word Attachment is:
http://www.excelforum.com/attachment...7&d=1145138050

--

CLR Wrote:
The font on both my office machine XL97/SR2 and this home machine
XL97/SR1
is the standard Ariel. As I said, at work if I enter Alt-1234 I get
the Pi
symbol with CODE() reading 45, but, here at home by typing in Alt-1234
I get
just a hyphen with CODE() reading 45..........also on this machine I
have
XL2k and it returns the hyphen and CODE() 45 also.........I have no
clue to
the mechanics of it all, just reporting what I've seen.....

Vaya con Dios,
Chuck, CABGx3

..




"Bryan Hessey"

wrote in message
news:Bryan.Hessey.26bc5z_1145116802.3261@excelforu m-nospam.com...

Hi,

Can I ask which Font you are using, as I need Alt-112 (or Alt-0112)
with the Symbol font to produce a Pi symbol. (Windows XP, Office
2003)

I use the attached sheet (Chars, is like Charmap with addresses) to
determine which characters will be displayed for the relavant
Alt-code
for the currently selected Font, and note that where a 4 digit code
Alt-0nnn to Alt-0255 is entered the chacters from rows 17 to 29 of
worksheet Chars are displayed, whereas if Alt-nnn to Alt-255, or a
calculated figure are used then characters from rows 3 to 15 are
displayed.

The 'calculated figure' - it seems that for any Alt-entry not in the
Alt-0 to Alt-256 or Alt-0000 to Alt-0256 ranges that the character
displayed is the Mod of the entered code divided by 256 (or
thereabouts). I did a partial construction of numbers Alt-1000+ and
Alt-2000+, and these seem to follow the plan.

If this is correct, then the '1' is your Alt-1234 cannot be returned
as
it is not (as I had previously thought) a 'code', but is just a part
of
a 'to big' code that is trimmed to the 0-255 range.

If anyone has a better understanding of the Alt-code system I would
welcome a better explanation, however to Gary''s Student's original
question, I have no method to determine whether the character was
the
result of an Alt-0nnn or 'other' entry, ie, whether the display came
from rows 3-15 or 17-29.

Bryan

Attachment is:

http://www.excelforum.com/attachment...4&d=1145115775

CLR Wrote:
Just a point of reference, in my Excel97, SR2......when I type
Alt-1234
in
A1, A1 displays the Pi symbol, and =CODE(A1) shows 45. If I type
in
Alt-045, the cell displays a hyphen. If I type in a hyphen,
=CODE(A1)
shows
45 again........also, Chip's CodeView Add-in follows suite.

Vaya con Dios,
Chuck, CABGx3



"Gary''s Student" wrote:

What is the function to return the code associated with a
unicode
symbol? If
I enter ALT-1234 in cell (say A1), I get a pi-type symbol:

â•¥

However CODE(A1) returns a 63. How can I get the 1234 back?
--
Gary''s Student



+-------------------------------------------------------------------+
|Filename: Chars2.zip
|
|Download: http://www.excelforum.com/attachment.php?postid=4634
|

+-------------------------------------------------------------------+

--
Bryan Hessey

------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=532566



+-------------------------------------------------------------------+
|Filename: Chars2Wb.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4637 |
+-------------------------------------------------------------------+

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532566

I don't know what the character is called Brian, but at K13 is a upper case
E with a miniature carrat ^ symbol above it......this is in
XL97/SR1.......and the same thing in XL2k.....and CODE(K13) returns 202

hth
Vaya con Dios,
Chuck, CABGx3




"Bryan Hessey"
wrote in message
news:Bryan.Hessey.26btiy_1145139301.3201@excelforu m-nospam.com...

CLR,

I too run standard Arial, which displays my 'lack of' here because I
simply cannot see a Pi symbol on characters Alt-0 to Alt-1255, the
attached Word document shows a screen capture of the Alt-1000 to
Alt-1255, which are the same characters as displayed in Alt-0 to
Alt-255 range offset by 1024

(I used the screen capture so that different systems fonts would not
affect the view)

In a DOS window, the CHCP command confirms my codepage is 850, I also
tried 437 and 852 but the Alt-1234 remained as a E+tilde character.

If you loaded my Chars2.wks, could you please select the Chars sheet,
select the fonttest range, and select Arial as the font (it was set to
Symbol to locate a Pi symbol) and confirm what character is displayed
at K13

Thanks

Word Attachment is:
http://www.excelforum.com/attachment...7&d=1145138050

--

CLR Wrote:
The font on both my office machine XL97/SR2 and this home machine
XL97/SR1
is the standard Ariel. As I said, at work if I enter Alt-1234 I get
the Pi
symbol with CODE() reading 45, but, here at home by typing in Alt-1234
I get
just a hyphen with CODE() reading 45..........also on this machine I
have
XL2k and it returns the hyphen and CODE() 45 also.........I have no
clue to
the mechanics of it all, just reporting what I've seen.....

Vaya con Dios,
Chuck, CABGx3

..




"Bryan Hessey"

wrote in message
news:Bryan.Hessey.26bc5z_1145116802.3261@excelforu m-nospam.com...

Hi,

Can I ask which Font you are using, as I need Alt-112 (or Alt-0112)
with the Symbol font to produce a Pi symbol. (Windows XP, Office
2003)

I use the attached sheet (Chars, is like Charmap with addresses) to
determine which characters will be displayed for the relavant
Alt-code
for the currently selected Font, and note that where a 4 digit code
Alt-0nnn to Alt-0255 is entered the chacters from rows 17 to 29 of
worksheet Chars are displayed, whereas if Alt-nnn to Alt-255, or a
calculated figure are used then characters from rows 3 to 15 are
displayed.

The 'calculated figure' - it seems that for any Alt-entry not in the
Alt-0 to Alt-256 or Alt-0000 to Alt-0256 ranges that the character
displayed is the Mod of the entered code divided by 256 (or
thereabouts). I did a partial construction of numbers Alt-1000+ and
Alt-2000+, and these seem to follow the plan.

If this is correct, then the '1' is your Alt-1234 cannot be returned
as
it is not (as I had previously thought) a 'code', but is just a part
of
a 'to big' code that is trimmed to the 0-255 range.

If anyone has a better understanding of the Alt-code system I would
welcome a better explanation, however to Gary''s Student's original
question, I have no method to determine whether the character was
the
result of an Alt-0nnn or 'other' entry, ie, whether the display came
from rows 3-15 or 17-29.

Bryan

Attachment is:

http://www.excelforum.com/attachment...4&d=1145115775

CLR Wrote:
Just a point of reference, in my Excel97, SR2......when I type
Alt-1234
in
A1, A1 displays the Pi symbol, and =CODE(A1) shows 45. If I type
in
Alt-045, the cell displays a hyphen. If I type in a hyphen,
=CODE(A1)
shows
45 again........also, Chip's CodeView Add-in follows suite.

Vaya con Dios,
Chuck, CABGx3



"Gary''s Student" wrote:

What is the function to return the code associated with a
unicode
symbol? If
I enter ALT-1234 in cell (say A1), I get a pi-type symbol:

â•¥

However CODE(A1) returns a 63. How can I get the 1234 back?
--
Gary''s Student



+-------------------------------------------------------------------+
|Filename: Chars2.zip
|
|Download: http://www.excelforum.com/attachment.php?postid=4634
|

+-------------------------------------------------------------------+

--
Bryan Hessey

------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=532566



+-------------------------------------------------------------------+
|Filename: Chars2Wb.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4637 |
+-------------------------------------------------------------------+

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532566