number 12 digits to 15 digits

M

mehdy-e

How can i use number more than 12 digit without rounding?I want to show for
examples exactly this number 1234567891234
 
M

Ms-Exl-Learner

Just format the cell as Text and try to enter the value.

Select the range and do Right Click and select Format
Cells>>Number>>Category>>Text and give ok.

Otherwise before entering the value in a cell type ' and enter the numbers.

If this post helps, Click Yes!
 
D

David Biddulph

But if you do it that way, many functions will not treat it as a number, and
will ignore it.
 
J

Jim Thomlinson

So long as your number is 15 digits or less then there is no problem. format
the number using

Format | Cells... | Number

Additionally you need to make sure that the column width is large enough to
display the number.

If you go over 15 digits then there is no way to avoid rounding.
 
G

Gord Dibben

You speak of 12 digits and 15 digits.

Your example has 13 digits.

What do you want to happen with your numbers?

Not clear from your description.


Gord Dibben MS Excel MVP
 

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

12 digit number rounding down why? 5
How do I get a column with 12 digit numbers to only show the 1st 1 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Showing 18 digits or more in a cell 1
I cannot enter a number containing more than 15 digits in Excel 1
Maximum amount of numbers in one Cell 2
last 2 digits 2
Converting a 10 digit serial number to a date of mm/dd/yyyy 7

Top