Format large numbers

[Gregfox]

Hello,
I have some simple VBA code that puts a 24 digit number into a worksheet, from the web. Tthe number always shows up as 2.46104E+22 (scientific) instead of 24610431121004074034237. I’ve tried to custom format it to no avail.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Is there a way to display the full number?<o></o>
Thanks.

 

[VoG]

Excel will only display numbers to 15 significant digits.

Try saving as a text string.

 

[Gregfox]

thanks, nevet thought of that....