Excel Maximum viewable numbers in a cell

T

Tony

A cell doesn't seem to show more than 16 numers it turns the last 3, in my
case, to zeros. ie 8944456845364785123 is shown as 8944456845364785000. Not
a big user of Excel, hense this, i assume a simple solution.
 

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

Extracting just the time portion 5
Returning a label rather than a number in pivot table field 1
Nested If statement to control format of number-type cells 3
I give up, trying to sum with non numeric cells. 2
finding the maximum number of used cells in any column of a table 6
Excel maximum Row number 2
How do I increase viewable cell character count limit in Excel? 2
testing range of cells for part of cell content 5

Top