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

    Unanswered: Remove a Dash in Front of a Number?

    Hello,

    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
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Use the ABS function to remove the negative https://support.office.com/en-us/art...a-c99d7c87713c

    Choose which ever method of rounding is applicable for your needs https://support.office.com/en-za/art...5-5c2cdb4b45f6

    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 https://www.google.co.uk/search?q=mi...+time+function
    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
    Posts
    150
    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
  •