New to VBA: Doubles

[pevbaroxs]

I'm just starting out. I am aware of what a Double is, I just don't understand why it defaults to it.

When I enter this: PercentError = 100.*abs((ExcelPi-myPi)/ExcelPI)

the "." after 100 changes to #. Why is it automatically changing it to a double?

Thanks,

pevbaroxs

 

[JLGWhiz]

I think the logical explanation is that the compiler sees the period and automatically assumes a decimal value is expected, so it simply identifies the value as a double since it does not otherwise know what the period is for. If you do not want it to be a double, don't use the period.