|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 17th, 2010, 01:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
March 17th, 2010, 01:20 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
12 digit number rounding down why?
Can you give an example or two?
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Lyd" wrote in message ... 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
|
|
#3
March 17th, 2010, 03:47 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
12 digit number rounding down why?
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 On Wed, 17 Mar 2010 06:00:01 -0700, Lyd wrote: 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
|
|
#4
May 10th, 2010, 07:10 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. 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...ming-in-c.aspx
|
|
#5
May 10th, 2010, 07:16 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Correction
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 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: On Monday, May 10, 2010 2:10 PM Leah S 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/tutorials...nd-the-li.aspx
|
|
#6
May 10th, 2010, 08:56 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Correction
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 On Mon, 10 May 2010 11:16:37 -0700, Leah S wrote: 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 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
