Solved

Member of An Array of Numbers Has # Following Number

Posted on 2011-09-22
2
327 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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

717 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