12 digit number rounding down why?

[Lyd]

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

 

[Bernard Liengme]

Can you give an example or two?
best wishes

 

[Gord Dibben]

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

 

[Leah S]

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 MV

wrote:

Previous Posts In This Thread:

12 digit number rounding down why?
12 digit number entered with cell formatted as just a number is rounding t
end in zero all the time. Help please. cell is not locked

Can you give an example or two?
Can you give an example or two
best wishe
-
Bernard Liengm
Microsoft Excel MV
http://people.stfx.ca/bliengme

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 MV

wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Parallel Programming in C# 4.0: A Short Synopsis
http://www.eggheadcafe.com/tutorial...4-b0f20bdc955a/parallel-programming-in-c.aspx

 

[Leah S]

I guess the credit card numbers are 16 digits. Wasn't thinking. Is there any way around the auto correct for that 16th digit?



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 MV

wrote:

Previous Posts In This Thread:

12 digit number rounding down why?
12 digit number entered with cell formatted as just a number is rounding t
end in zero all the time. Help please. cell is not locked

Can you give an example or two?
Can you give an example or two
best wishe
-
Bernard Liengm
Microsoft Excel MV
http://people.stfx.ca/bliengme

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 MV

wrote:

12 digits - auto change
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.


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Binding Beyond the Limitation of Name Scopes
http://www.eggheadcafe.com/tutorial...f-49faac8854c8/wpf-binding-beyond-the-li.aspx

 

[Gord Dibben]

Precede the numbers with an apostrophe which won't show in the cell.

OR pre-format the cell as Text then enter the 16 digits


Gord Dibben MS Excel MVP