Results 1 to 3 of 3

Thread: Custom Formats

  1. #1
    lethink
    Guest

    Custom Formats

    When trying to create a custom format I am getting an error that says "Cannot add any more custom formats." Does anyone know if there is a way to remove custom formats once they are created? I have a bunch of old ones that I don't use but I can't figure out how to get rid of them.

    Thanks,

    KML

  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: Custom Formats

    Goto to the number Format dialog and select an existing custom format that you do not want. An option to delete should be available once a custom format is selected. Just click on delete and that should do it. You can repeat ads required.

    That works in Excel 2000, but if I recall a similar procedure was available in Excel 97.

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Custom Formats

    Hi,

    As suggested, you can delete a custom format by going to the Format | Cells | Number tab and selecting Custom. Then select the format you no longer need. This works in Excel 97 too.

    Note there are about 36 custom formats that come with Excel. You can't delete these. If you select 1 of these, the Delete button will remain inactive.

    Depending on the length of the custom formats you've already defined, Excel will store about 180-260 custom formats. It seems like the space for these formats is governed by the number of characters taken up by them (some fixed length area somewhere), not the number of formats.

    fred

Posting Permissions

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