Quick question about the # in visual basic

What does it mean in visual basic (Excel) when it says i.e. A1=1#

or another example calculating the area of a cross section of a pipe

Area=(3.14*D^2)/4#

Does the # affect the numbers/equations in any way?

Hello Bjornast,

It is data type declaration indicating that the number is double floating point value (8 bytes). Yes it does effect the calculations.

Sincerely,
Leith Ross

Thanks for the quick answer.

bjornast