Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 07 Numbers default to fraction

Status
Not open for further replies.

jnameika

MIS
Mar 20, 2009
12
US
Using Excel 2007 and with cell formatted as Number I have to enter 5. or 500 for cell to equal 5. Even if decimal place = 0 it does not accept it as a whole number. Even if start with TEXT cell format if I change the cell to number it converts the value to a decimal moving the decimal two places to the left. Example: text = 8 convert cell to number the 8 is converted to .08. I don't have this problem in version 2003. I can't find anything regarding this issue or where I need to configure this option. I can't find any issues on Microsoft Technet, but I may not be using the correct phraseology to get a hit.

Thanks!
 

Press the Office Button ->Excel Options then click on Advanced. Make sure that under editing options the checkbox next to "Automatically insert a decimal point" is unchecked.

Hope this helps.

Please help us help you. Read Tek-Tips posting polices before posting.

Canadian members check out Tek-Tips in Canada for socializing, networking, and anything non-technical.
 
Yes. That worked. Thank you. I couldn't find the options button.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top