IT | HR | Accounts | Marketing | CS | |
Cost 1 | 58 | 501 | 8281 | -9991 | - |
Cost 2 | -102 | - | - | - | -3912 |
Cost 3 | - | 289 | -9382 | -2918 | 28581 |
I have a lot of columns and rows that I wished to convert the dash to "-" that matches the cell value and changes to 0. Is there any ways to do it the faster way? I have tried using filters and formula but it is simply too tedious as there are a lot of columns that I have to deal with the data.
IT | HR | Accounts | Marketing | CS | |
Cost 1 | 58 | 501 | 8281 | -9991 | 0 |
Cost 2 | -102 | 0 | 0 | 0 | -3912 |
Cost 3 | 0 | 289 | -9382 | -2918 | 28581 |
Solved! Go to Solution.
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |