Hi, this morning I suddenly want to write this topic. Yesterday, I make a report from existing report with Neo Office Spreadsheet that contains so many negative numbers inside it. And my new report will copy from original report but to positive number. Maybe this is not a trick, just a conventional way but maybe you don't know it yet.
Yup, if you want to make a positive number from negative number you can multiply it with -1, so you'd know if negative multiply with negative, it'll change to positive number. For example if you original number (negative one) in A1 cell that you fill B1 with -1 and in C1 contain formula : A1 * B1 so C1 will contains positive number, but this way is pretty annoying because you must multiply it column by column.
So, yesterday I think with feature in Paste Special dialog. Now, try with this way, type in A column with few negative numbers, then in B1 column (or in any column that you want) type -1 value, then copy B1 cell, then block all your negative numbers then right click to show context menu and choose Paste Special menu and in Paste Special dialog click Multiply option under Operations section then click OK button. And viola..... your negative numbers change to positive number. I think this way is shorter than first way.
I've try it with Neo Office but you can do the same action with Microsoft Excel and Open Office Spreadsheet application.

0 comments