In a specific workbook when i use Clear > All or Clear > Formats Excel sets the number format to Accounting instead of General.

This does not happen in other workbooks. It seems that Excel is using Accounting format as the "normal" format for this workbook.

Does anyone know if it possible to set the "normal" format for a workbook in Excel?


Excel uses the same principle of a normal style as Word does.

Hence to format the Normal style in Excel right click the style (in the Styles selection box) and click Modify ... then select Format ... and choose then in Number choose the format that best suits your needs.

Please see image bellow.

Picture: Excel Modify cell format

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.