# dat entry in Excel dividing all numbers by 100

**URL:** <https://boards.straightdope.com/t/dat-entry-in-excel-dividing-all-numbers-by-100/181291>\
**Category:** Factual Questions\
**Created:** [June 12, 2003, 6:34am UTC](https://boards.straightdope.com/t/dat-entry-in-excel-dividing-all-numbers-by-100/181291 "2003-06-12T06:34:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Scorpio](https://avatars.discourse-cdn.com/v4/letter/s/a88e57/32.png) [@Scorpio](https://boards.straightdope.com/u/Scorpio)\
**Post date:** [June 12, 2003, 6:34am UTC](https://boards.straightdope.com/t/dat-entry-in-excel-dividing-all-numbers-by-100/181291/1 "2003-06-12T06:34:20Z")

</div>

My work colleague is having a problem in Excel where if she enter in ‘1’ it changes to ‘0.01’, and so on for all numbers.

We have tried changing the cell format and percentage but that hasn’t helped. It’s happening in all worksheets of that file and is also happening if she starts a whole new file.

Any ideas would be appreciated.

---

<div class="post-metadata">

**Author:** ![Scorpio](https://avatars.discourse-cdn.com/v4/letter/s/a88e57/32.png) [@Scorpio](https://boards.straightdope.com/u/Scorpio)\
**Post date:** [June 12, 2003, 6:35am UTC](https://boards.straightdope.com/t/dat-entry-in-excel-dividing-all-numbers-by-100/181291/2 "2003-06-12T06:35:32Z")

</div>

Forgot to say, Excel 2000, Windows 2000.

---

<div class="post-metadata">

**Author:** ![AllShookDown](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@AllShookDown](https://boards.straightdope.com/u/AllShookDown)\
**Post date:** [June 12, 2003, 11:57am UTC](https://boards.straightdope.com/t/dat-entry-in-excel-dividing-all-numbers-by-100/181291/3 "2003-06-12T11:57:25Z")

</div>

From the menu at the top of the screen, select Tools \> Options \> Edit, then clear the checkbox for Fixed Decimal.