Re: $$Excel-Macros$$ Setting a default cell format in excel 2007

[STDEV(i)]

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

Re: $$Excel-Macros$$ Setting a default cell format in excel 2007

[Shaik Waheed]

Hi,
I think the number formatting for style Normal got changed to some date
format. Change it back to General.

On Thu, Nov 17, 2011 at 11:18 AM, 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*

 ** **

 --
 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this message and its attachments that does not relate to the
 official business of Meru Cab Company Pvt. Ltd. must be taken not to have
 been sent or endorsed by any of them. Email communications are not private
 and no warranty is made that e-mail communications are timely, secure or
 free from computer virus or other defect.

 --
 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


-- 
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