Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default When using Excel 2007 when I enter a 1, I get this 0.01. What do .


  #2   Report Post  
Posted to microsoft.public.excel.misc
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:


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,718
Default When using Excel 2007 when I enter a 1, I get this 0.01. What

Click on Office Button Excel Options Advanced tab Uncheck Automatically
insert a decimal point


"Gord Dibben" wrote:

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change cursor direction after enter in 2007? wheape1 Excel Discussion (Misc queries) 3 May 14th 07 09:24 PM
how to enter key direction in microsoft 2007 vivian wu Excel Discussion (Misc queries) 0 May 2nd 07 10:06 PM
Problems with my links to an excel 2007 file from a word 2007 file sc Links and Linking in Excel 0 February 21st 07 10:12 AM
Auto enter date when data in enter in another cell Brian Excel Worksheet Functions 5 December 7th 06 06:44 PM
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. qwopzxnm Excel Worksheet Functions 2 October 20th 05 09:06 PM


All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"