• Custom Formats

    Author
    Topic
    #1768315

    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

    Viewing 1 reply thread
    Author
    Replies
    • #1778768

      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.

    • #1778798

      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

    Viewing 1 reply thread
    Reply To: Custom Formats

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: