ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Add parenthesis to numbers in cell (https://www.excelbanter.com/excel-worksheet-functions/16939-add-parenthesis-numbers-cell.html)

RVG

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.

Michael

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.



All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com