I want columns N and V to be set to text instead of general. Any ideas how
to do this when making a new worksheet?

Thanks in advance for the help, Ted

Hi Ted,

Create a template with the formats as you want them. This done by saving
the file as .xlt instead of .xls. This allows you to use the same template
consistently with all your models.

Cheers,
Jon

"pertimesco" wrote:

I want columns N and V to be set to text instead of general. Any ideas how
to do this when making a new worksheet?

Thanks in advance for the help, Ted

If you do this often, you can format a blank worksheet in your
workbook the way you want and use it as a template. Whenever you need
a new worksheet, copy your formatted one.

Don S

On Tue, 1 Mar 2005 00:35:04 -0800, "pertimesco"
wrote:

I want columns N and V to be set to text instead of general. Any ideas how
to do this when making a new worksheet?

Thanks in advance for the help, Ted