What does # symbol indicate in following equation

[ThrottleWorks]

Hi,

This is not a problem. Getting bored, so tried wrap text in different way.

'Dat.Cells.WrapText = (12345678901# * 0)'

While doing this, I realized that if digits exceeds 10 numbers, it get # symbol automatically.

If I write 'Dat.Cells.WrapText = (1 * 0)' then there is no symbol.
This # symbol does not have effect on end result, tried with MsgBox (12345678901# * 0).

Which gave me correct answer as 0.
Just curious to know, why does excel inserts # symbol.

Please note, this is not a problem hence posting in Lounge section.
Kindly delete the post if necessary.

Good day.

 

[Marc L]

Hi !

It's a type declaration character : it forces as Double …

See VBA help of variable types.
​

 

[ThrottleWorks]

Okay, got it ! Thanks a lot @Marc L Sir.