Thread: symbol
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default 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