Posted to microsoft.public.excel.programming

Terence[_2_] Terence[_2_] is offline

external usenet poster

Posts: 9

How to use a conversion function in a whole column

Hi,

I would like to apply a conversion function, e.g. Cstr(),
to the values in the whole column ,e.g. Column A (Start
from cell A2 since A1 is the column heading). How to do it?
Thanks a lot!

Terence

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
CSV Column Conversion	CJ Melo	Excel Worksheet Functions	2	October 31st 09 01:23 AM
Row to column conversion	[email protected]	Excel Discussion (Misc queries)	4	October 6th 08 03:33 AM
Perpelexing Row to Column conversion	Geno	Excel Discussion (Misc queries)	3	July 7th 06 04:04 PM
PV function conversion to SQL	[email protected]	Excel Discussion (Misc queries)	1	November 20th 05 03:37 PM
Excel Column and row conversion	MSM	Excel Discussion (Misc queries)	1	May 7th 05 03:12 PM

All times are GMT +1. The time now is 08:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us