Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008

    Unanswered: Remove a Dash in Front of a Number?


    How can I remove a dash (-) in front of a number?

    Excel Columns:

    Column D Column E
    12/24/15 =D2-TODAY() -13

    My numbers appear with a dash in front of them and I would like to get whole numbers. I tried reformatting, but I still cannot get a simple whole number.

    Your assistance is appreciated. :-)

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Use the ABS function to remove the negative

    Choose which ever method of rounding is applicable for your needs

    The only oroblem is if the value is a date or alphanumeric in which case you may need to convert to a number. Or if its date manipulation use the correct date time function for your requirements
    Last edited by healdem; 01-07-16 at 06:09.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2008
    Thank you healdem. I actually formulated the cell as =TODAY()-D9 and this removed the dash. Thanks again for coming to my aid. :-)

Posting Permissions

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