Solved

Member of An Array of Numbers Has # Following Number

Posted on 2011-09-22
2
322 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
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 …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

738 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