Do you want a programming solution or to do it without programming?
Also by GENERAL(6) do you mean numeric to 6 places? A 3 by 3 range of
sample data "before" and a 3 by 3 range of (desired) "after" would help,
including both numeric and alphabetic data.

On Thu, 28 Aug 2003 00:57:32 -0700, "Daryl" wrote:

Hi Guys,

Sorry if I sound real stupid but is there anyway that we
can control the column formatting in Excel 97 like let's
say column A = GENERAL(6), column B = GENERAL(4), column C
= TEXT(18) etc?

Appreciate any form of advice, thanks!!