can I format excel to see over 15 digits?

  • Thread starter Thread starter 818jaime
  • Start date Start date
8

818jaime

When I copy paste it can only see 15 numbers the 16th and 17th it
displays 0's can this be chaged to display proper numbers?
 
Only if you treat the cell as text (preformat the cell as text), then enter the
value.

Or start your entry with an apostrophe ('1234123412341234)
 
ps. If you're pasting, then paste the value into the formulabar. It'll avoid
problems.
 
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

Access Access 2003 - Filter records to show current week returning wrong values 0
numbers convert to formula in csv 1
How to save a 15 digit # in CSV without it changing to a formula? 1
more than 15 numbers in a cell? 7
Calculating a Check Digit Routine 4
Replacing last digit with Zero 2
Custom Number Format 15
15+ digit numbers 3

Back
Top