Thread: When I type in a 1 it puts up .0001 how do I change this?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote