Hi,
I have a column of numbers in percentage form and shown to one decimal place.
Can someone please tell me how to format the numbers so that negative numbers appear in red font and in brackets, without the minus sign?
Thanks!
Hi,
I have a column of numbers in percentage form and shown to one decimal place.
Can someone please tell me how to format the numbers so that negative numbers appear in red font and in brackets, without the minus sign?
Thanks!
Last edited by andrewc; 07-25-2019 at 10:31 AM.
Conditional formatting.
Highlight the column range, Format the column to Number & Brackets, go to CF Highlight Cell Rules, < less than, enter -1 in the range box, select custom format, font red.
Or if you need the % sign sign, change the number format to custom, and use 0.0_);[Red](0.0)"%"
Last edited by BlindAlley; 07-25-2019 at 09:04 AM.
Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:
Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.
Thank you!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks