Application.AutoPercentEntry Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

True if entries in cells formatted as percentages aren’t automatically multiplied by 100 as soon as they are entered. Read/write Boolean.

expression .AutoPercentEntry

expression A variable that represents an Application object.

This example enables automatic multiplication by 100 for subsequent entries in cells formatted as percentages.

Application.AutoPercentEntry = False