Posted to microsoft.public.excel.programming

[email protected] husky101@yahoo.com is offline

external usenet poster

Posts: 8

format column to text

Thanks very much Jim.

It works a treat.

Cheers Paul

Jim Cone wrote:
Paul,

wks2.Columns("D:D").NumberFormat = "@"

Jim Cone
San Francisco, USA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Column with currency & text - how to format?	Martin ©¿©¬ @nohere.net	Excel Discussion (Misc queries)	2	May 11th 08 04:52 PM
Setting Column format as text	deluth	Excel Programming	8	July 14th 05 11:31 PM
Max value in 1 column when all values format are text	coco	Excel Programming	2	June 21st 05 07:40 PM
Column format as Text	Bruce Roberson[_5_]	Excel Programming	3	February 14th 04 02:08 AM
column format as text	Sumesh[_2_]	Excel Programming	2	February 9th 04 01:38 PM

All times are GMT +1. The time now is 03:20 PM.

About Us

"It's about Microsoft Excel"