Alternatively you can use FormatNumber . In the example below, the average (4 in this case) is the number of digits required after the decimal point. More about this feature HERE
strTemp = FormatNumber (i,4,vbTrue)
There are some differences between the output of both functions. Depending on your requirements, you can use one or the other. Play with each function to get an idea of which function best suits your needs.
source share