ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   automatic division (https://www.excelbanter.com/excel-discussion-misc-queries/43023-automatic-division.html)

Bart

automatic division
 
if I type 1 it becomes 0.0001 , if I type 1.0 is becomes 1

Does anybofy know how to fix this?

Thanks

Bart



RagDyeR

<Tools <Options <Edit tab,

And *UNCHECK*
"Fixed Decimal Places".

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Bart" wrote in message
...
if I type 1 it becomes 0.0001 , if I type 1.0 is becomes 1

Does anybofy know how to fix this?

Thanks

Bart




David Billigmeier

Tools-Options-Edit Tab-Uncheck "Fixed Decimal"
--
Regards,
Dave


"Bart" wrote:

if I type 1 it becomes 0.0001 , if I type 1.0 is becomes 1

Does anybofy know how to fix this?

Thanks

Bart




All times are GMT +1. The time now is 02:27 AM.

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