ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   DEcimal Input (https://www.excelbanter.com/excel-discussion-misc-queries/193389-decimal-input.html)

Raul Sousa

DEcimal Input
 
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

DEcimal Input
 
Menu ToolsOptions 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" wrote in message
...
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?




Raul Sousa

DEcimal Input
 
thank you

"Bob Phillips" wrote:

Menu ToolsOptions 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" wrote in message
...
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?






All times are GMT +1. The time now is 08:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com