Showing 18 digits or more in a cell

B

Berol

Using Excel 2000 and would like to format a cell to show at least 18 digits
with no decimals. I have tried all format possibilities and they all seem to
not show all the digits, abbreviate the number or round off the digits over
15. How do I format to show all the digits
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How many number digits can I fit into one cell? 3
I cannot enter a number containing more than 15 digits in Excel 1
Cell format - wrap text 7
how to show all digits in a "Data Table" 2
how to write 1234567890123456789 into a cell with number format 3
How do I prevent the cell from changing the number I enter? 2
Format Cell and Data Validation 4
16 digits 10

Top