Have you ever struggled with editing your Spreadsheet document while on the go? Well, DocHub has an excellent solution for that! Access this online editor from any internet-connected device. It allows users to Negate dent in Spreadsheet files quickly and anytime needed.
DocHub will surprise you with what it offers. It has powerful capabilities to make whatever changes you want to your forms. And its interface is so simple-to-use that the whole process from start to finish will take you only a few clicks.
As soon as you complete modifying and sharing, you can save your updated Spreadsheet document on your device or to the cloud as it is or with an Audit Trail that includes all alterations applied. Also, you can save your paperwork in its initial version or convert it into a multi-use template - complete 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