When I type in 100 a 1 appears, 10000 and 100 appear

Hi

When I type in 100 I get a 1 appearing in a cell. If I type in 1 then .01
appears in a cell. The cells are formated as number with 2decimal places.
If I set format to percent, I type in a 1 and 1.00% is shown.
The numbers I'm typing in appear to be divided by 100.
Any suggestions

--
Regards
Andy

Use Tools|options form menu
Open Edit tab and clear the Fixed Decimals box
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"AndyB" <AndyB@discussions.microsoft.com> wrote in message
news:16954BEF-AE9E-4A64-A7CB-A4AD67039512@microsoft.com...
> Hi
>
> When I type in 100 I get a 1 appearing in a cell. If I type in 1 then .01
> appears in a cell. The cells are formated as number with 2decimal places.
> If I set format to percent, I type in a 1 and 1.00% is shown.
> The numbers I'm typing in appear to be divided by 100.
> Any suggestions
>
> --
> Regards
> Andy

Hi
Thank you for the answer. It worked perfectly. How the decimal tab got set
I've no idea! Anyway - Thank you again
--
Regards
Andy


"Bernard Liengme" wrote:

> Use Tools|options form menu
> Open Edit tab and clear the Fixed Decimals box
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "AndyB" <AndyB@discussions.microsoft.com> wrote in message
> news:16954BEF-AE9E-4A64-A7CB-A4AD67039512@microsoft.com...
> > Hi
> >
> > When I type in 100 I get a 1 appearing in a cell. If I type in 1 then .01
> > appears in a cell. The cells are formated as number with 2decimal places.
> > If I set format to percent, I type in a 1 and 1.00% is shown.
> > The numbers I'm typing in appear to be divided by 100.
> > Any suggestions
> >
> > --
> > Regards
> > Andy
>
>
>