Have you ever struggled with modifying your Spreadsheet document while on the go? Well, DocHub comes with a great solution for that! Access this online editor from any internet-connected device. It enables users to Negate bates in Spreadsheet files rapidly and whenever needed.
DocHub will surprise you with what it offers. It has powerful functionality to make whatever changes you want to your forms. And its interface is so straightforward that the whole process from start to finish will take you only a few clicks.
After you complete adjusting and sharing, you can save your updated Spreadsheet file on your device or to the cloud as it is or with an Audit Trail that includes all changes applied. Also, you can save your paperwork in its original version or turn it into a multi-use template - accomplish any document management task from anywhere with DocHub. Subscribe today!
[Music] hello everyone this is a quick video just to show how we could insert a negative value into some non adjacent cells in a column so the first thing were going to need to do is to set up a formula in the column next to our original column and this formula is going to insert a - before the contents of the original cell in this case so b3 so this is how we would write the formula with the quotations - ampersand and then III and you can see that it placed a negative value here now we need to copy that formula to whichever other cells we need a negative value in so Im going to go ahead and grab these ones here and then paste that formula and it will add that the - or negative symbol in front of the contents of all those cells the next thing we need to do is set up a filter so that we can get rid of all the blank cells and only have the negative values shown so well uncheck blanks and that will leave us with just those cells that have content here in column C now we can copy that a