VBA putting a "#" behind my number

[JBaum2000]

This is a weird problem I have never encountered before. I have some code that converts the number to it's full usable form, 1B to 1,000,000,000 for example, and for some reason the VBA editor automatically puts the "#" symbol behind the trillion number, making it so that the trillion addition won't work. Why might this be?

Please Login or Register  to view this content.

[Rick Rothstein]

That symbol is telling the compiler (when it activates) that the number is of data type Double (it cannot be a Long because it is larger than 2,147,483,647. Where is the code doing the "trillion addition"? Why don't you show us all of the relevant code so we can what you are doing which would help us in advising you how to fix it.

[hrlngrv]

What do you mean by 'the trillion addition won't work'? Also, Excel can't store VBA Decimal type values in cells. ALL VBA numeric values are converted to Double before those Double numeric values are entered into Excel cells.

[scottiex]

if it is confusing you, you can write 1000* 1000 * 1000 * 1000 for me that would be more readable anyway.

[jolivanes]

Could you use * (10000000 * 100000)
* scottiex is faster

[JBaum2000]

mmmmmmmmmmm

[JBaum2000]

That is not even a problem here. Where did you get that from?