Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    no more custom format numbers can be added (97)

    I get the above message when I try to add a new format. Any way round it?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: no more custom format numbers can be added (97)

    Cormac,

    As far as I know there is a limit, but that limit is more dependant on the complexity of the number formats, than the actual number used. It seems you might have reached the limit. You can delete any exisisting custom formats that you no longer need. Format, Cells, Number and select Custom. Go to the first format that enables the delete button, and go through all the formats from there, deleting the ones you no longer need.

    Andrew C

  3. #3
    New Lounger
    Join Date
    Nov 2008
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: no more custom format numbers can be added (97)

    <P ID="edit" class=small>Edited by gwhitfield on 12-Nov-01 06:17.</P>Hyperlinks added

    Hi Cormac,

    Contained within this link article: <A target="_blank" HREF=http://j-walk.com/ss/excel/eee/eee007.txt>http://j-walk.com/ss/excel/eee/eee007.txt</A> is some code which can be used to removed unwanted/unused Custom Number Formats. The code does not represenet a complete solution to the management of formats... but could point you in the right direction.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •