Subscribe
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
a Single Cell does not accept more than 15 numbers
(3 posts) (3 voices)-
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
Posted 2 years ago # -
Bhaving7
have a read of some alternative ways to tackle big numbers at: http://www.dailydoseofexcel.com/archives/2009/01/12/large-number-arithmetic/
Posted 2 years ago #
Reply
You must log in to post.
Welcome to Chandoo.org. New here?
Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.
