|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 13th, 2009, 09:52 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
number 12 digits to 15 digits
How can i use number more than 12 digit without rounding?I want to show for
examples exactly this number 1234567891234 
|
|
#2
November 13th, 2009, 10:00 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
number 12 digits to 15 digits
Just format the cell as Text and try to enter the value.
Select the range and do Right Click and select Format CellsNumberCategoryText and give ok. Otherwise before entering the value in a cell type ' and enter the numbers. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "mehdy-e" wrote: How can i use number more than 12 digit without rounding?I want to show for examples exactly this number 1234567891234
|
|
#3
November 13th, 2009, 10:38 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
number 12 digits to 15 digits
Format as number, (with zero decimal places, if that's what you want).
-- David Biddulph "mehdy-e" wrote in message ... How can i use number more than 12 digit without rounding?I want to show for examples exactly this number 1234567891234
|
|
#4
November 13th, 2009, 10:41 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
number 12 digits to 15 digits
But if you do it that way, many functions will not treat it as a number, and
will ignore it. -- David Biddulph "Ms-Exl-Learner" wrote in message ... Just format the cell as Text and try to enter the value. Select the range and do Right Click and select Format CellsNumberCategoryText and give ok. Otherwise before entering the value in a cell type ' and enter the numbers. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "mehdy-e" wrote: How can i use number more than 12 digit without rounding?I want to show for examples exactly this number 1234567891234
|
|
#5
November 13th, 2009, 04:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
number 12 digits to 15 digits
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. -- HTH... Jim Thomlinson "mehdy-e" wrote: How can i use number more than 12 digit without rounding?I want to show for examples exactly this number 1234567891234
|
|
#6
November 13th, 2009, 04:43 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
number 12 digits to 15 digits
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 On Fri, 13 Nov 2009 01:52:14 -0800, mehdy-e wrote: How can i use number more than 12 digit without rounding?I want to show for examples exactly this number 1234567891234
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
