Maximizing Connectivity & Productivity

Excel – Creating and Testing new custom number formats

Creating new custom number formats is a create, test – rework, retest cycle.  It is best to check how the number appears for positive, negative, zero and text values.  However, each time the format is tested, the custom string will appear in the list to be selected.

Be sure to go to the Format Cells dialog box and delete all these test sample format strings once you have created the correct custom format string.

Leave a Reply

You must be logged in to post a comment.

Mississauga, ON, Canada 905.607.3500