Same in later versions. Maybe he has something in autocorrect



--
Regards,

Peo Sjoblom




"Pete_UK" wrote in message
ups.com...
That's odd, because in XL 2000 I can type * followed by <Enter, or
+<Enter, or -<Enter, or /<Enter into a cell formatted as General
and get the symbols *, +, - and / respectively.

I had to change Tools | Options | Transition (tab) | Microsoft Excel
Menu or Help Key from "/" (default) to something else ("?") in order
to get the / visible.

Hope this helps.

Pete

On Aug 31, 12:14 am, Bonnie wrote:
Yes, that does seem to work (thank you) but is there no other way??
...it
seems ridiculous that when the text formatting specifically reads "the
cell
is desplayed exactly as entered." that it should do exactly that. Issue:
I
have to include this apostrophe trick in the instructions for completing
the
evaluation table--for all my users who are not Excel fans, and in a big
hurry!



"Peo Sjoblom" wrote:
Precede the entry with an apostrophe '
it will not be visible in the cell/table

--
Regards,

Peo Sjoblom

"Bonnie" wrote in message
...
I want to use + and / symbols as text (in a table to designate
positive or
negative evaluation), but formatting all cells in the document as
'text'
does
not keep Excel from recognizing them as computing functions. Here is
the
weird part. If I copy and paste a + or / character from a word
document,
it
will work, but I can't simply type + or / into the cell. Help???-
Hide quoted text -

- Show quoted text -