ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   When I type in a 1 it puts up .0001 how do I change this? (https://www.excelbanter.com/excel-discussion-misc-queries/233569-when-i-type-1-puts-up-0001-how-do-i-change.html)

expeditor

When I type in a 1 it puts up .0001 how do I change this?
 


Dave Peterson

When I type in a 1 it puts up .0001 how do I change this?
 
In xl2003 menus, check:
Tools|Options|Edit tab

Make sure Fixed Decimal Places is not checked.

This option makes it easy for accountancy types to enter money--but for the rest
of the world, it can be a pain.

expeditor wrote:

--

Dave Peterson

David Biddulph[_2_]

When I type in a 1 it puts up .0001 how do I change this?
 
Tools/ Options/ Edit:
Uncheck: Fixed decimal places.
--
David Biddulph

"expeditor" wrote in message
...





All times are GMT +1. The time now is 06:18 AM.

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