If it looks wrong, give it another example by typing what you want to see in one of the wrong cells.īe aware that any formula connected to this cell will break as this is now text. Then click on DATA (2), and Flash Fill (3) and it will mimic what you have done to all the others. Flash Fillįor a quick solution, in the column directly adjacent to the one with the numbers in, type exactly what you want to see as shown in (1) below. The are a number of ways to change multiple cells to start with the plus minus symbol. Below how to show a plus minus symbol next to a number without affecting the calculation. Quick answer is the a ± in front of any number turns that cell into text so any formula attached to that cell expecting a number will generate an error message.
0 kommentar(er)
