Microsoft Office Forums - View Single Post - Excel 2019: How to display the sign of numbers in another field in brackets?

Thread: Excel 2019: How to display the sign of numbers in another field in brackets?

View Single Post

Old

09-16-2021, 09:44 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows 10

Windows 10 jeffreybrown uses Office 2016

jeffreybrown uses Office 2016

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

You could easily use a custom format for this.

Custom Format

Right click cell (or Ctrl + 1)
Format Cells
Number
Custom
Type: "(+)"0;"(-)"0;

Reply With Quote