0
How to make excel cell editor property as text by default in excel.
Actually cell property is general.How can i make that as text in excel
(Right click on excel cell editor
click on format cell
In number tab it highlight general only
How can i change general to text default)
user111921
Posted 2012-01-03T04:27:06.310
Reputation: 121
1
But if you set all cells to Text formatting you lose the ability to enter formulas, in which case you might as well be using a table in Microsoft Word.
Mike Fitzpatrick
Posted 2012-01-03T04:27:06.310
Reputation: 15 062
1
Here're the official Microsoft instructions on how to start Excel with a specific workbook template. You need to review the last section called "Save workbook settings you want to use every time you start Excel with a workbook template (book.xlt)".
Use Mike Fitzpatrick's instructions to create the styling template.
dnbrv
Posted 2012-01-03T04:27:06.310
Reputation: 867
You could also change Personal.XLSX because Excel will use it by default for any new workbook – JMax – 2012-01-03T07:46:14.527
The question is about Excel 2003. – dnbrv – 2012-01-03T12:04:37.827
Damn! but my comment is still worth it with the Personal.xls – JMax – 2012-01-03T12:52:43.320
before modifying the cell its ok but after modifying cells and i change property then its not working.so by default i have to change one time and then changes will occur every time when ever iam using excel – user111921 – 2012-01-03T05:16:44.217