+ Reply to Thread
Results 1 to 5 of 5

How do I remove the Minus sign

  1. #1
    Registered User
    Join Date
    02-27-2025
    Location
    Alabama
    MS-Off Ver
    Office 16
    Posts
    10

    Question How do I remove the Minus sign

    I'm working on a spread sheet for my work that allows us to calculate schedule adherence (how closely we are following our breaks and lunches etc...) My formula is working perfectly, but there is a Minus Sign (-) before the percent. So, if I get 95% its showing -95%. I have searched and search on how to make this a positive number, but I'm finding nothing that works. I would really appreciate any help with this.

    thank you so much !

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,636

    Re: How do I remove the Minus sign

    Either reverse the subtraction or use ABS function.


    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Last edited by TMS; 03-19-2025 at 05:47 AM. Reason: Change "of" to "or" in line 1
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert ByteMarks's Avatar
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    3,139

    Re: How do I remove the Minus sign

    Was going to suggest the ABS function, but I see TMS has done so already.

  4. #4
    Registered User
    Join Date
    02-27-2025
    Location
    Alabama
    MS-Off Ver
    Office 16
    Posts
    10

    Creating Pop Up Messages and Questions

    I am working on a spreadsheet that will help my coworkers with keeping up with their clock-in/out times as well as the codes we are using for the times. I have searched YouTube videos and Google help pages and there are a couple of things that I just can not get it right.

    * There is a drop down list in column C (the list is listed out of sight for now in A100)
    I need what I think is a VBA Code so that if the word "System" is selected in column C, there is a pop up box that simply says "Don't forget to submit your system time in Genesys". I have tried so many different methods and I haven't found anything that works.

    * There is a button in Red Font below the box that says "Clear Entire Day". I am trying to make a pop up question that says, "You are about to clear all entries for the entire day. This can not be undone. Are you sure you want to proceed?" with a yes or no option.

    I am new to the Macro world and any help with these 2 things would be greatly appreciated. I'm at an end on how to make this work.

    Thank you again so much !

    I have tried over and over to attach the excel sheet here and it says "The following error occurred: Tracker 2025.xlsm: Upload of file failed

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,636

    Re: How do I remove the Minus sign

    A new question requires you to start a new thread.


    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Remove the minus sign & fixed number
    By JACK JOUSH in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2024, 06:36 AM
  2. minus sign not working
    By kylefoley76 in forum Excel General
    Replies: 2
    Last Post: 06-28-2016, 12:32 PM
  3. Getting Plus/Minus Sign to Appear When Appropriate
    By vinceancona in forum Excel General
    Replies: 9
    Last Post: 06-06-2013, 02:08 PM
  4. displaying a minus sign
    By Blake 7 in forum Excel General
    Replies: 3
    Last Post: 02-03-2011, 08:11 AM
  5. minus sign
    By stevekirk in forum Excel General
    Replies: 9
    Last Post: 11-29-2006, 02:51 PM
  6. minus sign
    By tom mcdonald in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2006, 05:10 AM
  7. I want to display the minus sign
    By ED in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 10-27-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1