Forum Discussion
Exel formulas don´t work anymore
Evert1959 On the home tab you'll find a group of icons for "Numbers". If it says "Text" like in the picture when you have selected C2, it's a text.
By the way, the same could be the case for C1 and B2. You could also use a formula like =ISNUMBER(C2) to see if the cell contains a number or not. If TRUE than it's a number, if FALSE it's a text.
Evert1959 On the home tab you'll find a group of icons for "Numbers". If it says "Text" like in the picture when you have selected C2, it's a text.
By the way, the same could be the case for C1 and B2. You could also use a formula like =ISNUMBER(C2) to see if the cell contains a number or not. If TRUE than it's a number, if FALSE it's a text.
If in cell you have time 10:00 and add integer, you will see same 10:00 if hh:mm is applied to both cells.
To see the difference use full datetime format or elapsed time format [hh]:mm
Above in right column are exactly the same values (=left cell value + 5)
