Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2011, 09:59 PM
weety weety is offline Excel not entering numbers correctly Windows 7 64bit Excel not entering numbers correctly Office 2010 64bit
Novice
Excel not entering numbers correctly
 
Join Date: Jun 2011
Posts: 12
weety is on a distinguished road
Default Excel not entering numbers correctly


I can strart a brand new spreadsheet, enter a number and it will appear at 1/10 of what i enter. Eg. enter 100 it displays 10. No matter how I format the cells it does not change. Any suggestions?
Reply With Quote
  #2  
Old 06-29-2011, 12:51 AM
OTPM OTPM is offline Excel not entering numbers correctly Windows 7 32bit Excel not entering numbers correctly Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Weety
We would need to see a copy of your spreadsheet (or a sample extract) for us to see what is happening. We may then be able to advise you.
Have you checked to see if ANY conditional formatting has been applied to the template you are using?
Tony(OTPM)
Reply With Quote
  #3  
Old 06-29-2011, 01:07 AM
weety weety is offline Excel not entering numbers correctly Windows 7 64bit Excel not entering numbers correctly Office 2010 64bit
Novice
Excel not entering numbers correctly
 
Join Date: Jun 2011
Posts: 12
weety is on a distinguished road
Default All sorted now thanks

I found that for some reason in the advanced options tab the box titled "Automatically insert decimal point" was checked. After unchecking all is fine.

Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel not entering numbers correctly Excel 2011 not performing paste special correctly mzimmers Excel 1 01-04-2011 06:17 AM
Entering a postal bar code Sistafatti Word 0 07-14-2010 02:58 PM
Excel not entering numbers correctly creating unique numbers in excel bignick270 Excel 1 05-17-2009 05:40 AM
Entering Contact details GemmaD Outlook 0 12-18-2008 06:41 AM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft