Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set defaul to "text"
Is there a way to set the default cel number format to "text?"
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set defaul to "text"
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. "Rosewood" wrote: Is there a way to set the default cel number format to "text?" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set defaul to "text"
Highlight the cell range you wish to format as text.
then go to the menu, Format, Cells... Under Categoies select Text. Done.. "Rosewood" wrote: Is there a way to set the default cel number format to "text?" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set defaul to "text"
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. "Jonathan Cooper" wrote: 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. "Rosewood" wrote: Is there a way to set the default cel number format to "text?" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) | |||
I have to double click a cell for the "text" format to take | Excel Discussion (Misc queries) | |||
How to keep "text" number from changing to date.... | New Users to Excel | |||
.csv drops "0" when saved, even if file was set as "text". | Excel Discussion (Misc queries) | |||
Addition on "text" cells | Excel Discussion (Misc queries) |