Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using + and / as characters not as functional formatting
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??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using + and / as characters not as functional formatting
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??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using + and / as characters not as functional formatting
you could precede the + and / with a single apostrophe
'+ '/ or use ="+" ="/" "Bonnie" wrote: 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??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using + and / as characters not as functional formatting
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??? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using + and / as characters not as functional formatting
You mention positive and negative.
What problem are you having when you try to enter a +50 OR -100 into a Text *pre* formatted cell? Isn't the minus sign good enough to symbolize a negative? If you must use the slash, try the " \ " instead of " / ". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bonnie" wrote in message ... 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??? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using + and / as characters not as functional formatting
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 - |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using + and / as characters not as functional formatting
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 - |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using + and / as characters not as functional formatting
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 - |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using + and / as characters not as functional formatting
Like Ragdyer, I had no problems w/+ when the cell was pre-formatted as text.
I can use the / key if I go to Tools/Options/Transition and delete the / under Microsoft Excel menu or help key (or change it to something else). But each of your users would need to do this on their machines if they don't like '/. Or you could disable it w/a macro when they open the workbook by putting this code in the Thisworkbook module in the VBA editor Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error Resume Next Application.TransitionMenuKey = strTransitionMenuKey End Sub Private Sub Workbook_Open() On Error Resume Next With Application strTransitionMenuKey = .TransitionMenuKey .TransitionMenuKey = "" End With End Sub and this in a regular VBA module: Public strTransitionMenuKey As String if you are new to macros, there are some instructions on David McRitchies site: http://www.mvps.org/dmcritchie/excel/excel.htm "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??? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Nearly Non Functional | Excel Discussion (Misc queries) | |||
Fully functional spreadsheets on web? | Excel Discussion (Misc queries) | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
what does the term"functional summary" mean when creating a resum. | Excel Discussion (Misc queries) | |||
Non-functional Popup Menu Boxes | Charts and Charting in Excel |