View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruce Roberson[_5_] Bruce Roberson[_5_] is offline
external usenet poster
 
Posts: 6
Default Column format as Text

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?