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