Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
symbol
In cell A1, I have ... a (a symbol)
In A2, I have ... =code(A1) ... the display value is 63. In A3, I have ... =char(A2) ... the display value is ? (a question mark). How come ? Thanks Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
symbol
63 is the code number for the ? character
so char(63) gives ? -- steveB Remove "AYN" from email to respond "SP" wrote in message ... In cell A1, I have ... a (a symbol) In A2, I have ... =code(A1) ... the display value is 63. In A3, I have ... =char(A2) ... the display value is ? (a question mark). How come ? Thanks Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
symbol
You're probably using a different font in A1 and A3.
For instance, CHAR(63) in TNR or Arial is a question mark. CHAR(63) in Symbol is the symbol of a hand holding a writing implement. In article , "SP" wrote: In cell A1, I have ... a (a symbol) In A2, I have ... =code(A1) ... the display value is 63. In A3, I have ... =char(A2) ... the display value is ? (a question mark). How come ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
symbol
CODE/CHAR worksheetfunctions only work with ASCII characters and cant handle unicode use 2 udf's to sort it out: Function UniCode(ByVal sChar As String) UniCode = AscW(sChar) End Function Function UniChar(ByVal lUnicode As Long) UniChar = ChrW(lUnicode) End Function -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam JE McGimpsey wrote : You're probably using a different font in A1 and A3. For instance, CHAR(63) in TNR or Arial is a question mark. CHAR(63) in Symbol is the symbol of a hand holding a writing implement. In article , "SP" wrote: In cell A1, I have ... a (a symbol) In A2, I have ... =code(A1) ... the display value is 63. In A3, I have ... =char(A2) ... the display value is ? (a question mark). How come ? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
symbol
Or what did you expect to see or want to see
Font Tables as Rendered by your browser http://wwww.mvps.org/dmcritchie/rexx/htm/fonts.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm In article , "SP" wrote: In cell A1, I have ... a (a symbol) In A2, I have ... =code(A1) ... the display value is 63. In A3, I have ... =char(A2) ... the display value is ? (a question mark). How come ? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
symbol
(corrected link)
Font Tables as Rendered by your browser http://www.mvps.org/dmcritchie/rexx/htm/fonts.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type a symbol useing shortcut keys rather the insert a symbol | Excel Discussion (Misc queries) | |||
Euro symbol displays as dollar symbol in Excel | Excel Worksheet Functions | |||
SYMBOL ¦please help how do i do this symbol without copy/pasting i | Excel Worksheet Functions | |||
what shortcut key do I use for the + symbol over the - symbol | Excel Discussion (Misc queries) | |||
I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) |