Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 13th 09, 10:52 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2009
Posts: 1
Default 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   Report Post  
Old November 13th 09, 11:00 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 506
Default 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   Report Post  
Old November 13th 09, 11:38 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default 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   Report Post  
Old November 13th 09, 11:41 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default 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   Report Post  
Old November 13th 09, 05:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,941
Default 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   Report Post  
Old November 13th 09, 05:43 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you change single digits to recognized double digits? Evil with a K[_2_] Excel Worksheet Functions 4 May 18th 09 09:19 PM
4 digits required for a number Sandeep Excel Worksheet Functions 1 September 9th 08 01:19 AM
Sum of digits in a number Bob Ptacek Excel Worksheet Functions 3 January 8th 08 01:49 AM
How to customize number to 10 digits including 2 digits after deci Carina Excel Worksheet Functions 3 September 20th 07 02:50 AM
help with removing digits from a number frank Excel Discussion (Misc queries) 4 July 12th 05 02:31 AM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017