LinkBack URL
About LinkBacksWhat 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
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://msdn.microsoft.com/library/de...arsettopic.asp
?
--
Originally Posted by Gary''s Student
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
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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
--
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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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"
> > <[email protected]>
> > wrote in message
> > news:[email protected]...
> > >
> > > 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
>
Chuck,
That is what I get if I do Alt-1234
However, 1234 - 1024 = 202, and the E^ appeared to be at 210, a difference of 8 that I had not understood as 202 is a drawing character, double line down intersecting double horizontal lines.
However Alt-0202 is a E^ and a code of that = 202
This I find strange, as row 3-15 are Alt-0 to Alt-255 entered codes,
rows 17-29 are Alt-0000 to Alt-0255 entered,
and rows 32 onwards are Alt-1000 + entered.
As you see, most of the Alt-1000 codes resemble rows 3-15, and do not resemble the Alt-0000 range at rows 17-29.
I thought that Chars2.wks was sufficient documentation, but apparently not.
If you do Alt-1234 in a DOS window do you still get the Pi ?
(click Start, Run and type CMD
type CHCP to display your Codepage - mine is 850
EXIT to leave DOS)
OK - I will play some more, maybe I need to start my PC, perhaps this laptop with it's pretend numeric keypad (using 7 8 9, u i o, j k l and m keys) is the difference, but I would doubt that.
Sinking deeper into the character mire . .
--
> If you do Alt-1234 in a DOS window do you still get the Pi ?
> (click Start, Run and type CMD
> type CHCP to display your Codepage - mine is 850
> EXIT to leave DOS)
I just tried this in XL97/SR1 and got the Pi symbol in my DOS
window...........only difference, in WinMe I had to type Command instead of
just CMD
Vaya con Dios,
Chuck, CABGx3
"Bryan Hessey" <[email protected]>
wrote in message
news:[email protected]...
>
> Chuck,
>
> That is what I get if I do Alt-1234
>
> However, 1234 - 1024 = 202, and the E^ appeared to be at 210, a
> difference of 8 that I had not understood as 202 is a drawing
> character, double line down intersecting double horizontal lines.
>
> However Alt-0202 is a E^ and a code of that = 202
>
> This I find strange, as row 3-15 are Alt-0 to Alt-255 entered codes,
> rows 17-29 are Alt-0000 to Alt-0255 entered,
> and rows 32 onwards are Alt-1000 + entered.
> As you see, most of the Alt-1000 codes resemble rows 3-15, and do not
> resemble the Alt-0000 range at rows 17-29.
>
> I thought that Chars2.wks was sufficient documentation, but apparently
> not.
>
> If you do Alt-1234 in a DOS window do you still get the Pi ?
> (click Start, Run and type CMD
> type CHCP to display your Codepage - mine is 850
> EXIT to leave DOS)
>
> OK - I will play some more, maybe I need to start my PC, perhaps this
> laptop with it's pretend numeric keypad (using 7 8 9, u i o, j k l and
> m keys) is the difference, but I would doubt that.
>
>
> -Sinking deeper into the character mire . . -
> --
>
> CLR Wrote:
> > 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"
> > <[email protected]>
> > wrote in message
> > news:[email protected]...
> > >
> > > 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"
> > > > <[email protected]>
> > > > wrote in message
> > > > news:[email protected]...
> > > > >
> > > > > 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
> > >
>
>
> --
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks