If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Personalize the cell format
I had a personalized cell format in my Excel sheet, but
not that i have a french version, this format is not yet available. the only thing that i can do is to copy a cell with this format and paste it in the new spreadsheet. Is there a solution to have it always in the default choice... |
#2
|
|||
|
|||
Those custom formats travel with the workbook.
One way to make sure that all your new workbooks have this custom format is to create a Book.xlt (template workbook). Store it in your XLStart folder. In fact, you can specify everything you want new workbooks to have when they're created. Margins/page layout (portrait or landscape)/headers/footers and custom number formats. Apply your custom format to a cell in one of the worksheets in book.xlt. Then delete that column. Save your book.xlt and try it out. close excel restart excel click on that New Icon (under the excel icon adjacent to the File|Edit toolbar) (this won't help existing workbooks, though.) Alain Langelier wrote: I had a personalized cell format in my Excel sheet, but not that i have a french version, this format is not yet available. the only thing that i can do is to copy a cell with this format and paste it in the new spreadsheet. Is there a solution to have it always in the default choice... -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing format in combined cell | Lady Layla | General Discussion | 3 | September 16th, 2004 08:43 PM |
Formula controlling format based on content of a cell | Chris P | Worksheet Functions | 2 | May 26th, 2004 06:13 PM |
method to copy cell format through formula/VBA? | Paul Moles | Worksheet Functions | 0 | January 8th, 2004 12:12 PM |