Set defaul to "text"

[Rosewood]

Is there a way to set the default cel number format to "text?"

 

[Jonathan Cooper]

In a blank workbook, change all the cell formats to text. And then, assuming
your using Windows XP, Office 2003, save that workbook as a template, but
change the Save As location to:

C:\Documents and Settings\YourName\Application Data\Microsoft\Excel\XLSTART

replace "your name" with your user name.

Once saved here, every new workbook you create will default to text format.

 

[Jim May]

Highlight the cell range you wish to format as text.
then go to the menu, Format, Cells...
Under Categoies select Text.
Done..

 

[Rosewood]

Thanks so much- I will try that on the next project- am too far into this one
to change it. I will post the results.