This post is referring to??


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 10:20:04 -0700, dutch wrote:

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