| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
how do i make Excel 'remember' the custom formatting?
Thankfully and successfully I managed to format cells in Indian rupees like
12,34,567 and so on. I saved the Blank book as mormal .xlt. But, when I click open the new file ( by clicking the new icon on the menubar) teh customised formats are not available. I have to open the control N and then normal xlt from side bar. ANy suggestion to make Excel 2003 remember the customised formats? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
how do i make Excel 'remember' the custom formatting?
Save the workbook as a template named BOOK.xlt.
Store it in your XLSTART folder. This will become the default workbook for FileNew or New File Icon. But don't click on FileNew...Blabk workbook or you will get the Excel default workbook which you don't want. Gord Dibben MS Excel MVP On Mon, 26 Nov 2007 06:30:02 -0800, hirendra7158 wrote: Thankfully and successfully I managed to format cells in Indian rupees like 12,34,567 and so on. I saved the Blank book as mormal .xlt. But, when I click open the new file ( by clicking the new icon on the menubar) teh customised formats are not available. I have to open the control N and then normal xlt from side bar. ANy suggestion to make Excel 2003 remember the customised formats? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make "Insert Hyperlink" remember the last location | Links and Linking in Excel | |||
| How can i make a custom templet in excel? | Excel Discussion (Misc queries) | |||
| make custom formatting permanent | Excel Worksheet Functions | |||
| make custom header and footer in excel apply to all worksheets | Excel Discussion (Misc queries) | |||
| Can I make a custom button in Excel for the Group feature? | Excel Worksheet Functions | |||
Linear Mode
