software

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

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 quot;your namequot; with your user name.

Once saved here, every new workbook you create will default to text format.quot;Rosewoodquot; wrote:

gt; Is there a way to set the default cel number format to quot;text?quot;

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

gt; Is there a way to set the default cel number format to quot;text?quot;

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.

quot;Jonathan Cooperquot; wrote:

gt; In a blank workbook, change all the cell formats to text. And then, assuming
gt; your using Windows XP, Office 2003, save that workbook as a template, but
gt; change the Save As location to:
gt;
gt; C:\Documents and Settings\YourName\Application Data\Microsoft\Excel\XLSTART
gt;
gt; replace quot;your namequot; with your user name.
gt;
gt; Once saved here, every new workbook you create will default to text format.
gt;
gt;
gt; quot;Rosewoodquot; wrote:
gt;
gt; gt; Is there a way to set the default cel number format to quot;text?quot;