Maximizing Connectivity & Productivity

Excel – Change the default number format

The default number format in Excel is General.

To  set the default format, you have two choices.  One is to preformat the range of cells, or select and preformat the entire worksheet.  And the second, more preferable method,  is to change the Normal style, as the default format uses the Normal style.

To change the Normal style, click the Normal icon in the Home-> Syles group, click Modify, select the Format button, then select the Number Format to use.



Leave a Reply

You must be logged in to post a comment.

Mississauga, ON, Canada 905.607.3500