Entering More than 15 numbers

M

Mike

I'm trying to import numbers that are 25 characters in
length. When I do this (or even if I enter over the 15
character limit) I get an overflow number. How do I enter
or import numbers greater than 15 digits and have it
display the entire number. I am using Office XP.
 
P

Peo Sjoblom

precede with an apostrophe to get text, Excel's limit for numbers is 15
digits precision
 
E

Earl Kiosterud

Or you can format the cells for text in advance (Format - Cells - Number -
Text). With this, or the leading apostrophe, you're putting text into the
cell (not limited to 15 digits), not a number.
 

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

I cannot enter a number containing more than 15 digits in Excel 1
How can I work with more than 15 numbers 4
more than 15 numbers in a cell? 7
Importing Long Numbers as Text cells 1
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
15 digit limit 4
Sorting in Numerical Order 4
need way to handle large csv imports that overflow cell size 3

Top