Re: Can't clear the cell

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 01:48:21 -0600

In article <BCB31BFB.1BC8F%studiok4485@hotmail.com>,
 kevs <studiok4485@hotmail.com> wrote:

> I have a cell I'm trying to put a serial number in. It like 11 digits long.
>
> I select clear contents. I've formatted the cell to general.
>
> But when I hit enter it says 2.222222+11
>
> I have no idea what this means. Any ideas. Thanks

In General format, XL will try to fit the value into the cell width,
using Scientific Notation if necessary (it actually returns

        2.2222222E+11

which means 2.2222222 x 10^11

To display the value in regular notation, either make the cell wide
enough to hold the value (i.e., at least a width of 11), or choose
Format/Cells/Alignment/Shrink to Fit.

Relevant Pages

  • Re: DTPicker
    ... On the BestFit issue, for every cell of the column in the Flexgrid, I have ... I could not come up with a generic format to fit no matter ... > Hi Bob, ...
    (microsoft.public.vb.controls)
  • Re: Cell format problem
    ... type 61208E12 into a cell and it is reformatted as 6.12E+16. ... populated with identifiers such as 3B2, 3C2, 3E4 etc. ... have an "E" in them convert to Scientific Notation ... I click on the column and format the number type for the ...
    (microsoft.public.excel.misc)
  • Re: Completely baffled on what should be simple
    ... And remember just changing the format of the cell won't change the underlying ... sort, it didn't work. ... for the extensions that have either one or two 0's as the first numbers, ...
    (microsoft.public.excel.misc)
  • Re: Cell format problem
    ... type 61208E12 into a cell and it is reformatted as 6.12E+16. ... party software - however I believe we have limited control over this. ... I click on the column and format the number type for the ... to Scientific Notation. ...
    (microsoft.public.excel.misc)
  • Re: Text formatted cells displaying numbers in scientific format
    ... When it 'sees' a large number it uses scientific format since ... I accept that Excel can't handle numbers greater than 15 digits and your ... string was 16 digits or more to be converted to a scientific value. ... It just doesn't display correctly in the cell (except after entering ...
    (microsoft.public.excel)