Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
wrap text multiple column with format | Excel Discussion (Misc queries) | |||
Column with currency & text - how to format? | Excel Discussion (Misc queries) | |||
How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm" | Excel Worksheet Functions | |||
How can I format text in a column on a landscape worksheet? | Excel Worksheet Functions | |||
column format as text | Excel Programming |