var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Remove a Dash in Front of a Number?
How can I remove a dash (-) in front of a number?
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. :-)
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 05:09.
I'd rather be riding on the Tiger 800 or the Norton
Thank you healdem. I actually formulated the cell as =TODAY()-D9 and this removed the dash. Thanks again for coming to my aid. :-)