LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Using + and / as characters not as functional formatting

Oops! She/he could be American and with them it's impossible in many cases
to tell
gender from name, not that I noticed the name in this case anyway before I
posted that <bg


--
Regards,

Peo Sjoblom



"Pete_UK" wrote in message
oups.com...
I think Bonnie is a "she", Peo <g

Pete

On Aug 31, 12:47 am, "Peo Sjoblom" wrote:
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 -- Hide quoted text -


- Show quoted text -





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Nearly Non Functional Desert Doug Excel Discussion (Misc queries) 10 June 10th 07 05:39 AM
Fully functional spreadsheets on web? famdamly Excel Discussion (Misc queries) 4 April 18th 06 10:21 AM
Conversion of Cell Contents into a Functional Worksheet name ? GMJT Excel Worksheet Functions 1 August 21st 05 04:59 PM
what does the term"functional summary" mean when creating a resum. mzkc Excel Discussion (Misc queries) 1 April 6th 05 04:15 PM
Non-functional Popup Menu Boxes Jim_M Charts and Charting in Excel 0 January 20th 05 04:27 PM


All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"