Tip #075 – Excel

Excel: Identifying those nasty text cells

To perform calculations – of course you need NUMBERS. But in Excel you can sometimes have cells which appear to contain numbers but they really contain text. DATE cells especially.

 

To identify whether a cell contains text…use the T function and you’ll catch the culprit(s).

 

Full tip: Excel tip