realise this is much after the fact,

but i do believe it is not completely based on the of formatting of the column but how the column is being interpetted

if the data is of mixed type numerics and text it scans up to 30?? cells and uses that to determine if the entire column is to be read as text or numeric