Accounting Format (Excel 2013)

[Celtic2016]

Hi,

I'm currently working my way through the 2013 Excel MOS Expert study guide and one of the practice files includes the following question:

"Modify one of the built in accounting formats to display a text message when a cell's displayed value equals zero"

Anybody who could explain how to do this??

[candybg]

Without giving you explicit directions, instead of choosing a preset number format (ie currency or percentage or time), choose CUSTOM.
This page explains about the CUSTOM format:
http://www.exceltactics.com/definiti...formats-excel/

Hope this helps!