Excel tests for numbers seen as text

Please sign up for the course before starting the lesson.

If it is a proper number it should align to the right, be possible to format it into different number types and currencies, add it up by highlighting the cells, not have an apostrophe in front of the number, not have a zero as the starting number, Excel warns you with a little green note in the top left corner and gives a FALSE when tested with the ISNUMBER formula

Back to: Data cleanup in Excel > Convert 'Text' fields into usable numbers