| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| Sorting a six digit number by terminal digit | Excel Worksheet Functions | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Linear Mode
