Prev: Excel slow to close
Next: pivot table 2007 formatting does not stay when refreshing
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 close
Next: pivot table 2007 formatting does not stay when refreshing