Edit a Custom Number Format

  • Is it possible to "edit" a custom number format? Excel limits the maximum number of custom number formats, if I made a spelling error, and all I want to do is edit the format, can this be done. The reason I want to edit instead of deleting, is because custom number formatting is quirky, and when I delete a format, it shifts other custom formats within the workbook to a different saved custom number format (I would save a sample workbook, but not sure how to save a "deleted" number format).

    Any help would be appreciated

  • Hi,

    Quite an out-of-the-ordinary question ... !!!

    This would require some digging ...

    Meanwhile, could the macro designed by Leo Heuser be of any help ?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)