![excel symbols read as number excel symbols read as number](https://support.content.office.net/en-us/media/47aed473-3728-4264-a5ee-51bc79c311b0.png)
Change text to numbers with Paste Special The green triangle has disappeared and the values are now right aligned.
![excel symbols read as number excel symbols read as number](https://www.myexcelonline.com/wp-content/uploads/2016/02/Screenshot-161.png)
Once again, these calculations can be changed by users so it’s not a perfect check. And if any are text, only the count is performed. If the values are all numeric, you will probably see average, count and sum calculations. However, it is a great place to start and a good clue to look out for.Īnother way of checking is to select the range of values and look at the calculations down on the Status Bar. This is just a clue and not guaranteed, because users can change the alignment of cell values. So, if a value is left-aligned, it is probably text. However, there are some things to look out for, and ways to accurately check it.įirstly, Excel will always display text to the left of a cell and numeric values to the right of a cell. This causes much confusion for Excel users. It can appear as a number, yet be stored as text. It is not always clear that a number is stored incorrectly.
#Excel symbols read as number how to
How to check if a value is numeric or text