When raw data (in text *txt or csv format) is imported to excel, the conversion can sometimes have an unintended side-effect – the numbers come out as text after the process. The only choice left is to identify the columns that contain numbers masquerading as text and then to use the text to column option on each of the columns one-by-one. If the number of columns is large, eyeballing the data can be a bit of a strain.
Here a quick tip to help with the process using custom format – simply select all the cells in the worksheet by :
1. Pressing ctrl + a (use that command twice if excel selects only the adjacent cells)
2. Then pressing ctrl + 1
3. enter [Red]@ in the ‘Format Cells’ -> Custom box
Any cells with text (as opposed to numbers) will now get highlighted in Red. Its now a fairly easy job to identify the columns which have numbers appearing as text and to then selectively use the text to column option.