Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inputting data with a "+" sign
Is there an option in XL that if I type data into a cell with a + sign
at the beginning the + sign will remain? For example, in cell A1, if I enter, "+125", the "+" goes away and leaves the "125". I want the "+" to stay. For example, if I typed "=125" the "=" stays, but I want to type "+125" and have the "+" stay. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
inputting data with a "+" sign
Change your format to Text. It will accept whatever you type there. Excel
handles +125 as a positive integer and lops off the + as you have seen. "Native" wrote: Is there an option in XL that if I type data into a cell with a + sign at the beginning the + sign will remain? For example, in cell A1, if I enter, "+125", the "+" goes away and leaves the "125". I want the "+" to stay. For example, if I typed "=125" the "=" stays, but I want to type "+125" and have the "+" stay. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
inputting data with a "+" sign
Pre-format the cells for TEXT or type a leading apostrophe in front of the +
sign Vaya con Dios, Chuck, CABGx3 "Native" wrote: Is there an option in XL that if I type data into a cell with a + sign at the beginning the + sign will remain? For example, in cell A1, if I enter, "+125", the "+" goes away and leaves the "125". I want the "+" to stay. For example, if I typed "=125" the "=" stays, but I want to type "+125" and have the "+" stay. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
inputting data with a "+" sign
Either format the cell as TEXT, or type an apostrophe before the +.
Type: '+125 Displays: +125 The apostrophe is not displayed, but everything following it will be displayed as text. HTH, Elkar "Native" wrote: Is there an option in XL that if I type data into a cell with a + sign at the beginning the + sign will remain? For example, in cell A1, if I enter, "+125", the "+" goes away and leaves the "125". I want the "+" to stay. For example, if I typed "=125" the "=" stays, but I want to type "+125" and have the "+" stay. Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
inputting data with a "+" sign
The "=125" stays because it is a formula saying "This cell is equal to
125" To keep the "+" you could enter a custom number format of "+0;-0" (for numbers without decimals). You wouldn't need to enter the "+" as positive numbers would include the "+" via the format. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
inputting data with a "+" sign
Thanks for the replies. However, why I want to do this is so I can type
in say "+54", then if at a later time I want to add 125 to that 54, I can just open the cell and hit "+125" and the cell display 179. As it works now, if I hit "+54" then go to add additional numbers later, I hit [F2] then hit [Home], then "=", then [End], then "+125". I'd like to minimize all these key strokes especially when I have hundreds of data entry cells to change. OR, is there a way to have one of the keypad numbers start data entry in a new cell with an "=" input? For example, I've found if I go to start inputting data into a cell with the "/" key next to NumLock, it's like hitting the [Alt] key. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
inputting data with a "+" sign
That's a problem. Entering a new number or formula overwrites the
existing number or formula. There is no way to tell Excel to add what you just typed in to what was already there. You can update the cells in question in a couple of ways: You could enter your update figures in another column, row, or array the same shape as the range you're updating, then copy the whole range and use Paste Special to paste the Values with an Add operation into the original data. This will add the new figures to the existing ones. After that you delete the update figures. A nice feature of this is that you can double-check the new figures before adding them to the original figures. And you just need to type in numbers. You can use a series of cells in which you put in your numbers to come up with a total which you would calculate in another cell. For example, A1 might hold your total, and B1, C1, D1, etc, would hold the figures that make up the total. Or you could put those figures under cell A1 in A2, A3, and so on. New figures go into their own cells. You can reconcile figures back several iterations this way. And again, you only need to type in numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
Inputting Source Data - help please | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |