Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
+ or - as text, not math function
When entering + or - alone in a cell, Excell assumes a math function and
enters other characters. How can I get it to accept these as "text" and leave it that way. (Formatting as text doesn't work. Entering a ' first does, but doubles keystrokes.) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
+ or - as text, not math function
On Wed, 5 Nov 2008 17:51:01 -0800, MLM wrote:
When entering + or - alone in a cell, Excell assumes a math function and enters other characters. How can I get it to accept these as "text" and leave it that way. (Formatting as text doesn't work. Entering a ' first does, but doubles keystrokes.) Format it as text BEFORE entering the leading plus or minus signs. Works here (XL 2007) --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
+ or - as text, not math function
(Formatting as text doesn't work. ..
Pre-formatting the input range as TEXT seems to work ok for me here -- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
+ or - as text, not math function
Hi,
Could you please tell you Excel Version. I've checked in Excel 2003, Service Pack 3 and it also works the same as in Excel 2007. Might be you need to update your excel. anyways, Right Clik on any cell - Format Cells -Custom then in type text box enter +;- it should also work (here any number equal to or greater then 0 will be shown as + where as any number less than 0 wil be shown as -). But alas, to produce a negative sign you will have to hit 2 keys aleast. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Ron Rosenfeld" wrote: On Wed, 5 Nov 2008 17:51:01 -0800, MLM wrote: When entering + or - alone in a cell, Excell assumes a math function and enters other characters. How can I get it to accept these as "text" and leave it that way. (Formatting as text doesn't work. Entering a ' first does, but doubles keystrokes.) Format it as text BEFORE entering the leading plus or minus signs. Works here (XL 2007) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the real math behind PMT and IPMT function? | Excel Discussion (Misc queries) | |||
What is the math behind array function | Excel Discussion (Misc queries) | |||
Math Function | Excel Discussion (Misc queries) | |||
Need help with math Function | Excel Worksheet Functions | |||
Look up/math text | Excel Worksheet Functions |