M
mehdy-e
How can i use number more than 12 digit without rounding?I want to show for
examples exactly this number 1234567891234
examples exactly this number 1234567891234
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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!
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
Format as number, (with zero decimal places, if that's what you want).
D
David Biddulph
But if you do it that way, many functions will not treat it as a number, and
will ignore it.
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.
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
Your example has 13 digits.
What do you want to happen with your numbers?
Not clear from your description.
Gord Dibben MS Excel MVP