Thread: CODE
View Single Post
  #6   Report Post  
Dave R.
 
Posts: n/a
Default

And now you have the answer.. right? Alt-0160 or Alt-255.



"Hans Knudsen" wrote in message
...
Let me explain a bit.
I had downloaded some data (numbers) from our intranet and wondered why I

couldn't sum them. I tried more things including
multiplying the numbers by one but nothing seemed to work. Finally I

noticed that the the last digit of each number was followed by
a space. I tried to use Find/Replace All, that is Find Alt+032 and Replace

with nothing. This didn't work. Then I tried the same,
but instead of Alt+032 I used Alt+160 and then it worked. Now I could sum

the numbers.

If I enter for example the formula: =CODE("£")
then it returns 163.
So, by my question I meant. What should I enter instead of £ in above

formula to get the result 160 (only because I am curious to
know).

Regards
Hans Knudsen