I frequently have to use .xls or .csv files to import data into another
system, however the system requires that all fields be text (except
where a number is a genuine number).

My problem is that I have two colums of numbers that have to be
converted to text before I can run the import. Most users get this
right before they submit the files to me for processing, however a few
don't ! ! !

I use the format cells to make the columns text, but then have to press
F2 on every cell. This is not a problem when the file is up to 150
lines, but I have a couple of files where there could be 5,000 lines.

Does anyone know a formula that I can create/use to do this for me?

Thanks


--
masonap
------------------------------------------------------------------------
masonap's Profile: http://www.excelforum.com/member.php...o&userid=34783
View this thread: http://www.excelforum.com/showthread...hreadid=545398