15 digets
in [General]
|
Prev: Curser is selecting multiple cells
Next: How can you paste a spreadsheet from Excel without gridlines?
From: lostsoul62 on 3 Feb 2010 12:31 I'm trying to put in a 15 diget number and it keeps turning the last number to zero. I'm using excel 2007. Under format cell, I use numbers
From: Bernard Liengme on 3 Feb 2010 12:56 Excel has a limit of 15 digits. If your are working with really big umbers - meaning you want to do arithmetic operations on these numbers - then Excel is not for you. But if they are nor true numbers (ie things like credit card numbers) then they can be entered as text by 1) first formatting the cell as Text OT 2) typing a single apostrophe before the 'number' - the apostrophe will not display in the cell, nor will it appear in a print out. best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "lostsoul62" <lostsoul62(a)discussions.microsoft.com> wrote in message news:1AEE12B0-4228-47CF-861D-1CC9ABF5452E(a)microsoft.com... > I'm trying to put in a 15 diget number and it keeps turning the last > number > to zero. I'm using excel 2007. Under format cell, I use numbers
From: Joe User on 3 Feb 2010 13:01 "lostsoul62" wrote: > I'm trying to put in a 15 diget number and it keeps > turning the last number to zero. I'm using excel > 2007. Under format cell, I use numbers Examples?
From: מיכאל (מיקי) אבידן on 3 Feb 2010 13:11 I would suggest that you count the digits again. A quote from MS Article: -------------------------------------------------------------------------------------- Microsoft Excel retains 15 significant digits. To display all 15 digits, you must use a number format (custom or built-in) other than General. The General number format displays up to 11 numeric characters, with the decimal point counting as a numeric character. Therefore, if the number contains a decimal point, Excel can display up to 10 significant digits, but if the number does not contain a decimal point, Excel can display up to 11 significant digits Adding more numbers to the left of the decimal point causes the number to appear in exponential notation. ------------------------------------------------------------- Micky "lostsoul62" wrote: > I'm trying to put in a 15 diget number and it keeps turning the last number > to zero. I'm using excel 2007. Under format cell, I use numbers
From: Jim Thomlinson on 3 Feb 2010 13:19
A limitation of your computer is that it holds numbers accurately to a maximum of 15 digits. If you want more than 15 digits you can change the cell format to Text and re-enter the number or add a ' at the beginning of the number to denote it as text. -- HTH... Jim Thomlinson "lostsoul62" wrote: > I'm trying to put in a 15 diget number and it keeps turning the last number > to zero. I'm using excel 2007. Under format cell, I use numbers |