ThrottleWorks
Excel Ninja
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.
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.