Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hi all,
I created a new custom format in "Format Cells", after using this custom format I save the file and quit, when I open the old file the custom format still in this file, but when I try to create a new file the custom format is lost. Is it possible to keep the custom format forever in the Excel so that I don't need to create it again when open new workbook? Many Thanks. Buddy |
#2
![]() |
|||
|
|||
![]()
Hi Buddy
You can save a empty workbook as a template with this format and name it "Book" (no quotes) you must save it in your xlstart folder You can find it here in Excel 2003 C:\Program Files\Microsoft Office\OFFICE11\XLSTART Every new workbook you open now have this format -- Regards Ron de Bruin http://www.rondebruin.nl "Buddy" wrote in message ... Hi all, I created a new custom format in "Format Cells", after using this custom format I save the file and quit, when I open the old file the custom format still in this file, but when I try to create a new file the custom format is lost. Is it possible to keep the custom format forever in the Excel so that I don't need to create it again when open new workbook? Many Thanks. Buddy |
#3
![]() |
|||
|
|||
![]()
Thank you so much, I can do it now.
"Ron de Bruin" ¼¶¼g©ó¶l¥ó·s»D ... Hi Buddy You can save a empty workbook as a template with this format and name it "Book" (no quotes) you must save it in your xlstart folder You can find it here in Excel 2003 C:\Program Files\Microsoft Office\OFFICE11\XLSTART Every new workbook you open now have this format -- Regards Ron de Bruin http://www.rondebruin.nl "Buddy" wrote in message ... Hi all, I created a new custom format in "Format Cells", after using this custom format I save the file and quit, when I open the old file the custom format still in this file, but when I try to create a new file the custom format is lost. Is it possible to keep the custom format forever in the Excel so that I don't need to create it again when open new workbook? Many Thanks. Buddy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Custom Format for ¢ | Excel Discussion (Misc queries) | |||
Custom Time Format doesn't work for me | Excel Discussion (Misc queries) | |||
How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
Curious Worksheet Format | New Users to Excel |