• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

a Single Cell does not accept more than 15 numbers

B

bhaving7

New Member
Hi,


We are having issues with numbers that are larger then 15 in length, excel trims them and does not show them properly.


We want to show them as normal numbers


Pls guide
 
Microsoft Excel 2003 / 2007 have a 'Number Precision' limit of 15 digits in any one cell.


Depending on what you need to use the number for, you could format as 'text' to display all digits, although this may limit the functionality of the cell.


Hope this helps..


Regards


Chris Byham
 
Bhaving7


have a read of some alternative ways to tackle big numbers at: http://www.dailydoseofexcel.com/archives/2009/01/12/large-number-arithmetic/
 
You must log in or register to reply here.
Back
Top