Why # appears on its own ?

[Milind]

while using this code:
For each c Worksheets("Sheet1").Range("A2:A100").Cells

If c.Value = 235454567890 Then

A hash sign appears after this number in the coding. What does it signify ?

Milind

 

[Chip Pearson]

Milind,

It declares the number as a Double data type.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)