Solved

Member of An Array of Numbers Has # Following Number

Posted on 2011-09-22
2
305 Views
Last Modified: 2012-05-12
I have an array of numbers that are the results of the powers of two. All is well until the 31st entry and then the number gets a "#" appended to the number. The actual number is 2^31 or 2,147,483,648. Is there a limit to the size of a number that can be placed in an array? What is the significance of the "#" sign?

val1 = Array(1, 2, 4, 8, 16, _
             32, 64, 128, 256, 512, _
             1024, 2048, 4096, 8192, 16384, _
             32768, 65536, 131072, 262144, 524288, _
             1048576, 2097152, 4194304, 8388608, 16777216, _
             33554432, 67108864, 134217728, 268435456, 536870912, _
             1073741824, 2147483648#, 4294967296#, 8589934592#)
0
Comment
Question by:wmckinney
  • 2
2 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 50 total points
ID: 36581955
The # indicates that the value is treated as data type Double.  The Long data type tops out at (2 ^ 31) - 1.
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 36581966
BTW, Double tops out at ~1.79 x 10 ^ 308.  However, it is only precise to the first 15 significant digits.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now