Numerical characters in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Execll 2002 and cannot put more than 15 numbers in a cell before
it shortens the numbers. Is there a way of changing how many numerical
characters in a cell.
 
Excel only keeps track of 15 digits.

If you can treat the digits as text, you can prefix your entry with an
apostrophe:

'123451234512345

or preformat the cell as Text first (format|Cells|Number tab)
Then type in your entry.
 
You must log in or register to reply here.

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

remove alpha or non-numeric characters from cell 8
Prevent alpha character in numeric cell 2
Remove all Characters Remains only Numeric Data 5
converting text cell to numeric cell 5
Sorting in Numerical Order 4
formula with alpha char in cell 7
Data Validation 3
Excel Cell Format for Numberic Values 1

Back
Top