Have you ever had trouble with editing your Spreadsheet document while on the go? Well, DocHub comes with a great solution for that! Access this cloud editor from any internet-connected device. It allows users to Negate PII in Spreadsheet files quickly and anytime needed.
DocHub will surprise you with what it provides you with. It has robust functionality to make whatever changes you want to your forms. And its interface is so intuitive that the whole process from beginning to end will take you only a few clicks.
After you complete modifying 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 convert it into a multi-use template - complete any document management task from anyplace with DocHub. Sign up 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