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
|