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

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

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 ?

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 ?

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 ?

symbol
 

(corrected link)
Font Tables as Rendered by your browser
http://www.mvps.org/dmcritchie/rexx/htm/fonts.htm