Thread: When using Excel 2007 when I enter a 1, I get this 0.01. What do .
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default When using Excel 2007 when I enter a 1, I get this 0.01. What do .
With earlier versions you go into ToolsOptionsEdit and uncheck "fixed decimal
places"

2007 version should be similar.


Gord Dibben MS Excel MVP

On Sat, 19 May 2007 10:13:21 -0700, digger
wrote:


Reply With QuoteReply With Quote