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 "Like" icon ...just below...in the bottom right corner...:)