Why?:How do I change it back?

I try to enter info in a cell - type 0.77 and it changes to 1. How do I
change it back?

Anoli

Look at Tools/Options/Edit
Make sure "fixed decimal places" is not checked
Also, check the cell format, may be Number/No decimal places or Custom/ 0

Beege


"Anoli" <Anoli@discussions.microsoft.com> wrote in message
news:9043C701-C389-4985-9CE2-DD1E3435344E@microsoft.com...
>I try to enter info in a cell - type 0.77 and it changes to 1. How do I
> change it back?

Reformat the cell to format 0.00.

"Anoli" <Anoli@discussions.microsoft.com> wrote in message
news:9043C701-C389-4985-9CE2-DD1E3435344E@microsoft.com...
>I try to enter info in a cell - type 0.77 and it changes to 1. How do I
> change it back?

You could try increasing the number of decimal places displayed.

Click on the Increase Decimal icon on the Formatting Menu bar a couple of
times.

Note: a more specific description of your problem would get more people to
look and maybe respond.

Regards

Trevor


"Anoli" <Anoli@discussions.microsoft.com> wrote in message
news:9043C701-C389-4985-9CE2-DD1E3435344E@microsoft.com...
>I try to enter info in a cell - type 0.77 and it changes to 1. How do I
> change it back?