When I type in a 1 it puts up .0001 how do I change this?
|
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 |
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