 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Large integers in cells
Hi How can I make Excel show integers larger than 15 digits? I mean without showing it in squares of 10. 123456789012345 is largest I can make fully visible by changing cell type. After that, for example 1234567890123456 is shown as 1234567890123450 or 1,234567890123450E+14 depending on cell type. But NOT the way I'd like it. Is it possible to change the behaviour so I can see as long integer as fits to cell? regards Juha Immonen Not as an integer, as Excel only displays 15 digits and as you see it then adds zeroes, so without working in scientific notation...no If these are really text though (e.g credit card numbers), although you clearly state integer, you can add a leading apostrophe (') or pre-format the cell(s) as text. Excel will then display up to 256 in the cell or some larger number of characters in the formula bar  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > Hi > [quoted text clipped - 11 lines] > regards > Juha Immonen > Not as an integer, as Excel only displays 15 digits and as you see it then > adds zeroes, so without working in scientific notation...no. But won't it get inaccurate when lets say 12345678901234567890 is turned to 1,23456789012345000000E+19? Or what did you mean with this "scientific notation"? Pre-formatting to text seems to help seeing it all, but I really would need to do calculations on these, so it's out of question format. Result field should also have this "feature" and formulas won't fit to text cells. I assume this thing is hardcoded without possibility to change even via registry or anything? brgds Juha Immonen Hello Juha, Look here: http://digilander.libero.it/foxes/ I have not tested it - but it is mentioned in wikipedia ... HTH, Bernd > Look here: > http://digilander.libero.it/foxes/ > I have not tested it - but it is mentioned in wikipedia ... Looks very promising, although it's only capable of 200 digits. Does anyone have experience on this? Might it work with later Excels as well? Juha >>Look here: >>http://digilander.libero.it/foxes/ [quoted text clipped - 5 lines] > > Juha "only capable of 200 digits" ???? Those are pretty big numbers. Out of curiosity, just what are you doing that requires working with such large integers? If you really need that many significant digits, then I think I'd stay away from excel and try to find a different program. > Hi > [quoted text clipped - 11 lines] > regards > Juha Immonen SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.