View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Why # appears on its own ?

Milind,

It declares the number as a Double data type.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Milind" wrote in message
...
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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003