DEcimal Input

[Raul Sousa]

I use Excel for a long time, but something strange happen to me today.
It is using decimal numbers. The number introduced is different from what I
tape.
When I tape 100 it appears in that cell 1. If I tape 53, for example, it
appears 0.53.
What can the problem be? Is it possible to solve?

 

[Bob Phillips]

Menu Tools>Options and go to the Edit tab.

See if the Fixed Decimal box is checked, if so uncheck it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Raul Sousa]

thank you

Menu Tools>Options and go to the Edit tab.

See if the Fixed Decimal box is checked, if so uncheck it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)