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 |