CONCATĪ formula based option is using CONCAT (new version of CONCATENATE) where you just need to copy the ± symbol from somewhere and include it in the CONCAT formula as shown below.īe aware that any formula connected to this cell will break as this is now text. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |