When a custom format for percentages is created in XL2000 it appears only in
the file it was creaated in. Initially this meant recreating the format for
use in a different file; however, I did discover using the Format Painter
does transfer the custom format to a new file. This seems cumbersome. Is
there some obscure reason that a new custom format, once created, is not
available for every file

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions