From: Leah on 10 May 2010 14:10 This happens to me as well. If you enter a credit card number (12 digits) Excel automatically changes the last number to a Zero. The only way I found around this was to add the spaces like the credit card has, but I could not find a solution for adding 12 digit numbers together. We are using Excel 2003. Gord Dibben wrote: You sure it is only 12 digits? 17-Mar-10 You sure it is only 12 digits? Excel will add a zero after 15th digit. Never seen after 12 digits. Gord Dibben MS Excel MVP wrote: Previous Posts In This Thread: On Wednesday, March 17, 2010 9:00 AM Lyd wrote: 12 digit number rounding down why? 12 digit number entered with cell formatted as just a number is rounding to end in zero all the time. Help please. cell is not locked On Wednesday, March 17, 2010 9:20 AM Bernard Liengme wrote: Can you give an example or two? Can you give an example or two? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme On Wednesday, March 17, 2010 11:47 AM Gord Dibben wrote: You sure it is only 12 digits? You sure it is only 12 digits? Excel will add a zero after 15th digit. Never seen after 12 digits. Gord Dibben MS Excel MVP wrote: Submitted via EggHeadCafe - Software Developer Portal of Choice Parallel Programming in C# 4.0: A Short Synopsis http://www.eggheadcafe.com/tutorials/aspnet/047afdf6-61ab-4b85-9204-b0f20bdc955a/parallel-programming-in-c.aspx  |  Pages: 1 Prev: Excel slow to closeNext: pivot table 2007 formatting does not stay when refreshing