Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 14th 05, 08:59 AM
Buddy
 
Posts: n/a
Default Keep custom format in new worksheet

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   Report Post  
Old March 14th 05, 09:32 AM
Ron de Bruin
 
Posts: n/a
Default

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   Report Post  
Old March 14th 05, 10:03 AM
Buddy
 
Posts: n/a
Default

Thank you so much, I can do it now.

"Ron de Bruin" glsD
...
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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I format a cell for a custom part number? PJ Excel Discussion (Misc queries) 4 March 3rd 05 03:57 AM
Custom Format for ¢ Stephen POWELL Excel Discussion (Misc queries) 0 February 25th 05 07:11 PM
Custom Time Format doesn't work for me chuck Excel Discussion (Misc queries) 1 February 13th 05 04:12 AM
How do I copy a cell (content AND format) from one worksheet to a. Excel Format Copy Excel Worksheet Functions 1 February 9th 05 10:34 PM
Curious Worksheet Format PT New Users to Excel 1 December 9th 04 07:23 AM


All times are GMT +1. The time now is 06:22 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017