| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Add parenthesis to numbers in cell
When I put a number in a cell and then add a parenthesis when I leave that
cell to go to another the parenthesis changes to a minus sign and moves to right of cell. |
|
#2
|
|||
|
|||
|
Hi
putting numbers in brackets in Excel means to make them a negative. Try putting an apostrophe before the parentheses HTH Michael "RVG" wrote: When I put a number in a cell and then add a parenthesis when I leave that cell to go to another the parenthesis changes to a minus sign and moves to right of cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
| occurance of numbers in cell range | Excel Worksheet Functions | |||
| create a cell that accumulates, numbers from another cell... | Excel Discussion (Misc queries) | |||
| How can I write in a text in a cell using numbers and the letters. | Excel Discussion (Misc queries) | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
Linear Mode
