I often need to change the format of a cell to text. Whilst I do know how to
do this I frequently have to change a whole column into text and if this runs
to many hundreds I need a quick way to do it. Does anyone know how to do this
quickly and easily? Can a macro be created to do it for me for instance?

Thanks

Andrew

Highlight the entire column by left-clicking on the LETTER at the top, A, B,
C, etc. Then Right-click FormatCells NumberTab Text OK

Vaya con Dios,
Chuck, CABGx3



"Andrew" wrote:

I often need to change the format of a cell to text. Whilst I do know how to
do this I frequently have to change a whole column into text and if this runs
to many hundreds I need a quick way to do it. Does anyone know how to do this
quickly and easily? Can a macro be created to do it for me for instance?

Thanks

Andrew

Hi Andrew
Try recording what CLR suggested as a macro.
Check out the help files on 'Create a Macro' but basically do this
goto Tools - Macros - Record a Marco
create it in the active sheet and start recording then do what was sugested
below and when your done hit the stop button on the little popup window and
hey presto ..........you've got a macro that will format what evercolums you
selected in to text format. You can select multiple columns by holding the
ctrl key down as you make youre selection and when you've done the last one
then do the right clickformatcellsnumbertabtextok............now youve
done loads of columns in one go, Works accross sheets as well.
Once youve got the desired macro you can nick the code out of it by going to
tools - macros - select the one you want - edit and copying the bit that does
what you want.
You then could add a command button (contols toolbar) go to propeties and
change the Caption to say, 'Format to Text'. Then go to the sheet tab, right
click and view code.
Between the
Private Sub CommandButton1_Click()

End Sub
paste in the code from your recorded macro and now you can run the macro
from the button on your sheet.
If you want to change it back just record a macro doing just that and repeat
the rest.

I've only just started doing this kind of stuff and copy code from macros is
a great way of getting started.

"CLR" wrote:

Highlight the entire column by left-clicking on the LETTER at the top, A, B,
C, etc. Then Right-click FormatCells NumberTab Text OK

Vaya con Dios,
Chuck, CABGx3



"Andrew" wrote:

I often need to change the format of a cell to text. Whilst I do know how to
do this I frequently have to change a whole column into text and if this runs
to many hundreds I need a quick way to do it. Does anyone know how to do this
quickly and easily? Can a macro be created to do it for me for instance?

Thanks

Andrew