ISTEXT won't return true just because the cell is formatted as text. It
only will return true if you have a value in the cell. If you put a value in
the cell, then since it was preformatted as text, the value will be stored
as text and the function will return true.

--
Regards,
Tom Ogilvy


"Bruce Roberson" wrote in message
...
I recorded a macro that I thought would format column f as
text, and it records as shown below:

Columns("F:F").NumberFormat = "@"

It works for several columns, but it doesn't work in this
particular column. If you get in a cell beside it and
issue the following formula:

=istext(f2); the result is false, telling you that the
result is not text.

What can I do to change this to make it be text instead of
numeric?