It seems you need a new template standards. Open a new workbook Set the desired number of sheet in the workbook Select all sheets at once as a group Select all cells (Ctrl + A) Format the cells of this workbook in your own font-style, font-size, and so on, including the format number (= GENERAL) save the workbook with NAME: BOOK.XLTX (assumption: you you are the users of Excel 2007 / 2010) storage paths: If you are a Windows XP user the Templates folder is usually C:\Documents and Settings\\Application Data\Microsoft\Templates. In Windows Vista the Templates folder is usually C:\Users\\AppData\Roaming\Microsoft\Templates.
Make the same workbook but also contains only one sheet and save as SHEET.XLTX book.xltx will be used by Excel when you open a new workbook. sheet.xltx will be used by Excel every time you insert a new sheet. ~siti On Thu, Nov 17, 2011 at 12:48 PM, Amit Desai (MERU) <amit.de...@merucabs.com > wrote: > Dear Masters,**** > > ** ** > > Can you please let me know, how to set a default format for all cells in > excel 2007. As of now whenever I type any data it comes in date format, I > want to change this to general.**** > > ** ** > > Regards,**** > > *Amit Desai***** > > > ** > -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com