Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2021, 04:31 AM
Jamal NUMAN Jamal NUMAN is offline Excel 2019: How to display the sign of numbers in another field in brackets? Windows 7 64bit Excel 2019: How to display the sign of numbers in another field in brackets? Office 2010 64bit
Expert
Excel 2019: How to display the sign of numbers in another field in brackets?
 
Join Date: Nov 2010
Posts: 519
Jamal NUMAN is on a distinguished road
Question Excel 2019: How to display the sign of numbers in another field in brackets?

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



I couldn’t figure out how to display the sign of numbers in another field in brackets as shown in the screenshot below
Attached Images
File Type: jpg Clip_35.jpg (63.3 KB, 14 views)
Reply With Quote
  #2  
Old 09-16-2021, 04:54 AM
ArviLaanemets ArviLaanemets is offline Excel 2019: How to display the sign of numbers in another field in brackets? Windows 8 Excel 2019: How to display the sign of numbers in another field in brackets? Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Into B2 enter formula
Code:
=IF($A2="","",IF($A2<0,"(-)","(+)"))
and copy down
Reply With Quote
  #3  
Old 09-16-2021, 08:21 AM
Jamal NUMAN Jamal NUMAN is offline Excel 2019: How to display the sign of numbers in another field in brackets? Windows 7 64bit Excel 2019: How to display the sign of numbers in another field in brackets? Office 2010 64bit
Expert
Excel 2019: How to display the sign of numbers in another field in brackets?
 
Join Date: Nov 2010
Posts: 519
Jamal NUMAN is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
Into B2 enter formula
Code:
=IF($A2="","",IF($A2<0,"(-)","(+)"))
and copy down

Thank you for the answer.


What if i need to write the (-) and (+) in the same column as in the screenshot below?
Attached Images
File Type: jpg Clip_891.jpg (47.1 KB, 13 views)
Reply With Quote
  #4  
Old 09-16-2021, 09:44 AM
jeffreybrown jeffreybrown is offline Excel 2019: How to display the sign of numbers in another field in brackets? Windows 10 Excel 2019: How to display the sign of numbers in another field in brackets? Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown 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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2019 - Black Display when mouse hoovers over the main display CleoLane Outlook 2 09-06-2021 10:07 PM
Excel 2019: How to display the sign of numbers in another field in brackets? Excel 2019: How to display the file path on the title bar? Jamal NUMAN Excel 1 05-05-2020 04:23 AM
Merging phone numbers with + sign WibbleWobble Mail Merge 2 12-28-2019 04:29 AM
What's new in Word 2019, Excel 2019 and Outlook 2019 and Why upgrade to Office 2019 is recommended? einfomail Office 1 07-26-2019 09:44 AM
Excel 2019: How to display the sign of numbers in another field in brackets? How to add the plus sign (+) automatically for the numbers which are positive? Jamal NUMAN Excel 2 05-01-2011 03:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft