There seems to be two types of number in TEXT format.
Column A was formatted as TEXT before entering the numbers. They are left-aligned and there is a small green triangle on the top-left corner of each cell, indicating number in TEXT format. Column B was originally in GENERAL but after entering the formula "=A2+0", it automatically turned into TEXT format (as seen from Format/Format Cells or Ctrl-1). There is, however, no green triangle in the cell. Column C is in GENERAL format.
You can do simple math (addition, division, multiplication, division, Log, maybe others) on A as "=A2+A3" gives 3. Functions such as SUM fail though.
Column B, though left aligned implying TEXT, is just like regular number. SUM works on Column B. All functions and math operations should work on C as it is in GENERAL format.
TYPE(A2) gives 2, indicating TEXT format, while TYPE(B2) gives 1, indication number format. The latter is not in agreement with what one gets by clicking Format/Format Cells or Ctrl-1, both indicating column B is TEXT.
This is done on Excel 2010. Maybe the 2019 version gives the correction information.
TEXT | =A2+0 | General |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
6 | 6 | 6 |
7 | 7 | 7 |
8 | 8 | 8 |
| | |
0 | 36 | 36 |
=SUM(A2:A9) | =SUM(B2:B9) | =SUM(C2:C9) |
| | |
3 | | |
=A2+A3 | | |