LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
wrap text multiple column with format Meesh Excel Discussion (Misc queries) 1 September 10th 09 11:50 PM
Column with currency & text - how to format? Martin ©¿©¬ @nohere.net Excel Discussion (Misc queries) 2 May 11th 08 04:52 PM
How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm" nosam Excel Worksheet Functions 2 March 25th 05 04:09 PM
How can I format text in a column on a landscape worksheet? CK Excel Worksheet Functions 2 November 14th 04 07:32 PM
column format as text Sumesh[_2_] Excel Programming 2 February 9th 04 01:38 PM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"