set all cells format to be "TEXT" whenever I start a new xls file, by default

[loade]

hello!

how can I set all cells format to be "TEXT" whenever I start a new xls file?

thanks!

[Fotis1991]

Hi

Probably a macro will do the trick, but the easiest way to do this is to highlight the sheet(left of A column) and choose Text format.

[vlady]

can not say in excel 2003 but here's in 2010 maybe try it in 2003

open a new workbook
format the cells as "text"
save it to folder named xlstart
search for it. "xlstart" folder or counter part folder for xl2003

if you will not be permitted to save in that directory.
save it first to my document and copy paste it there (xlstart)

[loade]

can not say in excel 2003 but here's in 2010 maybe try it in 2003

open a new workbook
format the cells as "text"
save it to folder named xlstart
search for it. "xlstart" folder or counter part folder for xl2003

if you will not be permitted to save in that directory.
save it first to my document and copy paste it there (xlstart)

there is indeed a folder C:\Program Files (x86)\Microsoft Office\OFFICE11\XLSTART

however, I know that in MS Word, you can change the Normal.dot file, which is the default template for new doc files

is there anything similar for EXCEL?

[loade]

there is indeed a folder C:\Program Files (x86)\Microsoft Office\OFFICE11\XLSTART

however, I know that in MS Word, you can change the Normal.dot file, which is the default template for new doc files

is there anything similar for EXCEL?

I think I found the answer and I post it for anyone who it may concern:

http://www.ruschena.org/michael/?p=217