Syntax

expression.FixedDecimalPlaces

expression A variable that represents an Application object.

Example

This example sets the FixedDecimal property to True and then sets the FixedDecimalPlaces property to 4. Entering "30000" after running this example produces "3" on the worksheet, and entering "12500" produces "1.25."

Visual Basic for Applications 
Application.FixedDecimal = True Application.FixedDecimalPlaces = 4
Enter data with automatic two decimal places? Fix the decimal point for currency? fixed Fixed Decimal places Fixed Decimal Places Property FixedDecimal FixedDecimalPlaces FixedDecimalPlaces Property Set data entry to automatically show two decimal places?

See also: