Can you help me with my homework, teacher?

---

You can use the following basic syntax in VBA to format each cell in a range as a percentage.

Sub FormatPercent()
    Dim i As Integer

    For i = 2 To 11
    Range("A" & i).NumberFormat = "0.00%"
    Next i
    
End Sub

This particular example formats each cell in the range A2:A11 as a percentage value with two decimal places.

The following example shows how to use this syntax in practice.

Example: Format Cells as Percentage Using VBA

Suppose we have the following list of values in Excel:

Suppose that we would like to format each value as a percentage.

For example:

• 0.22 should be formatted as 22%.
• 0.35 should be formatted as 35%.

And so on.

We can create the following macro to do so:

Sub FormatPercent()
    Dim i As Integer

    For i = 2 To 11
    Range("A" & i).NumberFormat = "0.00%"
    Next i
    
End Sub

When we run this macro, we receive the following output:

Each value is now formatted as a percentage with two decimal places.

Note that the number of zeros after the decimal point in the NumberFormat property specifies the number of decimal places to display in each percentage.

Sub FormatPercent()
    Dim i As Integer

    For i = 2 To 11
    Range("A" & i).NumberFormat = "0%"
    Next i
    
End Sub

When we run this macro, we receive the following output:

Notice that the decimal places have been removed from each percentage value.

Note: You can find the complete documentation for the VBA NumberFormat property .