Panda Internet Security 2007 - $15 Discount Coupon
Download Free Web Design Software Here
Sponsors:
Recommended laptop
under £500.
under £500.
Think I deserve a present? See my Amazon Wish List
Microsoft Excel Large Number Error
Large number pasting / rounding errors
Excel will change any number pasted in longer than 15 digits in length to be correct for the first 15 digits then pad the rest of the number with trailing zereos.
If you collect a 16 digit number with spaces, like a credit card, "4111 1111 1111 1111", and paste it into Excel - it works as Excel sees the spaces and assumes text.
On the other hand if you have a proper number, such as 4111111111111111, paste it into Excel and you get 4111111111111110!
As Excel reads numbers with commas as numbers the following, 4111,1111,1111,1111 becomes 4,111,111,111,111,110
Related Links
- >How to Paste a Number with 16 Digits in Excel
- How to find a question mark in Microsoft Excel
- Microsoft Excel keyboard shortcuts
- Microsoft Excel how to password protect a document
- Microsoft Excel how to make a string into sentance case
Share this!
Excel Keyboard Shortcuts | Excel Large Number Error | Excel Large Number Paste
Link here: