Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Format Question
I would like to format my Excel 2007 so that every time I open a worksheet
it is automaticaly set up to be in a number format with 2 decimal places and using the comma separator every time I open up the worksheet. Presently I open up the workwheet and have to format the worksheet new every time I open it up. Being a CPA 99% of the worksheets I start need to be the number format. Would save me some time if every time I opened up a worksheet it was already formatted. Thanks Darrell A. Hillis, CPA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Format Question
This fix will work for changing the default for any new workbook that you
create. I got this to work. First, Hold the Window Key down and hit F to search your hard drive for the XLStart folder. Write down the path to that folder (ie. C:\Program Files etc.) Then open a blank workbook. On the Home tab, select "Cell Styles" in the "Styles" Grouping, then right click on "Normal" and select modify from the shortcut menu. Click the "Format" button, then format the number to use 1000 Separator with 2 decimal places. Click on OK. Then go to Save as Excel Workbook. Under save as type select "Excel Template", THEN save to the template with the name Book to the XLStart folder that you found earlier. From now on, any new workbook will have your number format right. Good luck and reply if you have any questions for clarification. "Darrell Hillis, CPA" wrote: I would like to format my Excel 2007 so that every time I open a worksheet it is automaticaly set up to be in a number format with 2 decimal places and using the comma separator every time I open up the worksheet. Presently I open up the workwheet and have to format the worksheet new every time I open it up. Being a CPA 99% of the worksheets I start need to be the number format. Would save me some time if every time I opened up a worksheet it was already formatted. Thanks Darrell A. Hillis, CPA |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Format Question
WARNING,
Any cell that you enter a number into will have this new format, even if you enter 9/2/08, it will display it as a decimal number. "Brad Vogt" wrote: This fix will work for changing the default for any new workbook that you create. I got this to work. First, Hold the Window Key down and hit F to search your hard drive for the XLStart folder. Write down the path to that folder (ie. C:\Program Files etc.) Then open a blank workbook. On the Home tab, select "Cell Styles" in the "Styles" Grouping, then right click on "Normal" and select modify from the shortcut menu. Click the "Format" button, then format the number to use 1000 Separator with 2 decimal places. Click on OK. Then go to Save as Excel Workbook. Under save as type select "Excel Template", THEN save to the template with the name Book to the XLStart folder that you found earlier. From now on, any new workbook will have your number format right. Good luck and reply if you have any questions for clarification. "Darrell Hillis, CPA" wrote: I would like to format my Excel 2007 so that every time I open a worksheet it is automaticaly set up to be in a number format with 2 decimal places and using the comma separator every time I open up the worksheet. Presently I open up the workwheet and have to format the worksheet new every time I open it up. Being a CPA 99% of the worksheets I start need to be the number format. Would save me some time if every time I opened up a worksheet it was already formatted. Thanks Darrell A. Hillis, CPA |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Format Question
Brad - Your Great -Thanks
Darrell "Brad Vogt" wrote: This fix will work for changing the default for any new workbook that you create. I got this to work. First, Hold the Window Key down and hit F to search your hard drive for the XLStart folder. Write down the path to that folder (ie. C:\Program Files etc.) Then open a blank workbook. On the Home tab, select "Cell Styles" in the "Styles" Grouping, then right click on "Normal" and select modify from the shortcut menu. Click the "Format" button, then format the number to use 1000 Separator with 2 decimal places. Click on OK. Then go to Save as Excel Workbook. Under save as type select "Excel Template", THEN save to the template with the name Book to the XLStart folder that you found earlier. From now on, any new workbook will have your number format right. Good luck and reply if you have any questions for clarification. "Darrell Hillis, CPA" wrote: I would like to format my Excel 2007 so that every time I open a worksheet it is automaticaly set up to be in a number format with 2 decimal places and using the comma separator every time I open up the worksheet. Presently I open up the workwheet and have to format the worksheet new every time I open it up. Being a CPA 99% of the worksheets I start need to be the number format. Would save me some time if every time I opened up a worksheet it was already formatted. Thanks Darrell A. Hillis, CPA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Excel Tab Question | Excel Discussion (Misc queries) | |||
How to format cells in Excel 2007 (i.e. currency format)? | Excel Discussion (Misc queries) | |||
Two question about Excel 2007 | Excel Worksheet Functions | |||
Convert Excel 2007 format (*.xlsx) into Excel 2003 format | Excel Discussion (Misc queries) | |||
Excel 2007 question? | Excel Worksheet Functions |