Hi:
I'm using Excel 2003. Anyone know how to get it to stop automatically
choosing a data type for my columns? Some of its automatic features
are nice but its auto data type sometimes gets in the way. Example, I
run a program which exports data to Excel. The data contains fractions
such as 5/6 and 6/6. When I open the newly-created Excel file, Excel
converts those fractions to dates such as May 6 and June 6. If I could
get to the worksheet ahead of time, I would format the column as text.
But it's too late by the time I look at the worksheet and converting to
text after Excel converts my fraction to a date results in just the
serial date entry.
Anyone know how to shut off the auto column data type feature?
Thanks!
Kevin
Bookmarks