PC Review


Reply
Thread Tools Rate Thread

How to add custom number format to Excel library?

 
 
G Lykos
Guest
Posts: n/a
 
      10th May 2007
Greetings! I have created some custom number formats that I would like to
have available to me in any workbook that I open. How do I accomplish this?

Thanks,
George


 
Reply With Quote
 
 
 
 
G Lykos
Guest
Posts: n/a
 
      10th May 2007
The other piece of this is that I would like them to be added to the foreign
workbook such that I can then send it to another person and the custom
formatting will be retained.

Thanks again!


"G Lykos" <(E-Mail Removed)> wrote in message
news:%23N$(E-Mail Removed)...
> Greetings! I have created some custom number formats that I would like to
> have available to me in any workbook that I open. How do I accomplish

this?
>
> Thanks,
> George
>
>



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      10th May 2007
If you create a workbook template named book.xlt and store it in your XLStart
folder, you can add the custom format to this workbook.

Excel will use that when you create a new workbook by clicking on the new icon
on the standard toolbar.

This won't affect any existing workbooks, though.

G Lykos wrote:
>
> Greetings! I have created some custom number formats that I would like to
> have available to me in any workbook that I open. How do I accomplish this?
>
> Thanks,
> George


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel 2007, can you add "custom" formats to number format dropd Robin B! Microsoft Excel Setup 1 21st Aug 2009 09:31 PM
Excel 2007 & Custom Number Format Limitations? TC Microsoft Excel Discussion 1 4th Jul 2008 03:22 PM
Custom Number Format Excel 2003 =?Utf-8?B?VG9kZEVa?= Microsoft Excel Programming 7 16th Mar 2007 07:45 PM
Excel Format Cells - Number Tab - Custom - Order of Type Window. =?Utf-8?B?RWQ=?= Microsoft Excel Misc 0 5th Feb 2007 03:44 PM
How do I create a custom number format in Excel using a symbol? =?Utf-8?B?bWJ1Y2tyZWxs?= Microsoft Excel Misc 2 26th Jul 2006 12:49 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:41 PM.