Tuesday, 28 July 2009

Custom Number Formatting in Excel

Undoubtedly one of Excel's sneakiest features, custom formatting unlocks a whole array of possibilities for formatting where conditional formatting is either not necessary or not available, for example in a chart's axes or data labels.

Read Jon Peltier's post on the topic for a good treatise on the subject and check the Microsoft Knowledge Base page for a full list of syntax.

No comments:

Post a Comment