Excel divides number by 10e6 unless followed by decimal point.

When I type a number into a cell Excel displays the number divided by
1,000,000 unless the number is followed by a decimal point. What can I do to
change this?

"JohnO" <JohnO@discussions.microsoft.com> wrote in message
news:07724E08-620E-4A0E-9FC6-A06C61B4BB24@microsoft.com...
> When I type a number into a cell Excel displays the number divided by
> 1,000,000 unless the number is followed by a decimal point. What can I do
to
> change this?
>
>

Format|Cells select number and number of decimals
/Fredrik

Tools|options|Edit tab
uncheck that "fixed decimal places" box.

JohnO wrote:
>
> When I type a number into a cell Excel displays the number divided by
> 1,000,000 unless the number is followed by a decimal point. What can I do to
> change this?

--

Dave Peterson

This is not a question of simply formating the cell, and specifying the
number of decimal points. General, Text, Number (with zero points) cell
formats all have the same result when a number is entered into the cell.

"Fredrik Wahlgren" wrote:

>
> "JohnO" <JohnO@discussions.microsoft.com> wrote in message
> news:07724E08-620E-4A0E-9FC6-A06C61B4BB24@microsoft.com...
> > When I type a number into a cell Excel displays the number divided by
> > 1,000,000 unless the number is followed by a decimal point. What can I do
> to
> > change this?
> >
> >
>
> Format|Cells select number and number of decimals
> /Fredrik
>
>
>

It worked. THANK YOU!!!

John O'Donnell

===========================

"Dave Peterson" wrote:

> Tools|options|Edit tab
> uncheck that "fixed decimal places" box.
>
> JohnO wrote:
> >
> > When I type a number into a cell Excel displays the number divided by
> > 1,000,000 unless the number is followed by a decimal point. What can I do to
> > change this?
>
> --
>
> Dave Peterson
>

John

Tools>Options>Edit. Uncheck "Fixed Decimal Places".


Gord Dibben Excel MVP

On Mon, 21 Mar 2005 16:31:07 -0800, "JohnO" <JohnO@discussions.microsoft.com>
wrote:

>When I type a number into a cell Excel displays the number divided by
>1,000,000 unless the number is followed by a decimal point. What can I do to
>change this?
>