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

If you have a column of numbers and you select the entire column and pull-down:
Format Cells... Text

all the cells should become text without F2 being needed on each cell
--
Gary''s Student


"masonap" wrote:


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

Hi

The only foolproof method I'm aware of is a formula like
="" & A1
, or
=TEXT(A1,"#.00")


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"masonap" wrote in
message ...

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

I have read the reply from Gary's student.

This does not solve the problem, I still need to F2 on every cell in
order to see the small green triange in the top left corner of the cell
which confirms that the cell is formatted as text correctly.


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

If my original suggestion did not work then:

Tools Options Error checking and clear the number stored as text
checkbox
--
Gary's Student


"masonap" wrote:


I have read the reply from Gary's student.

This does not solve the problem, I still need to F2 on every cell in
order to see the small green triange in the top left corner of the cell
which confirms that the cell is formatted as text correctly.


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