Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Dividing by 100!
Register FAQ Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2009, 05:47 AM
fkaramagi fkaramagi is offline
Novice
Dividing by 100! 		 
Join Date: Jan 2009
Posts: 1
fkaramagi is on a distinguished road
Default Dividing by 100!


Every figure I enter in any MS Excel 2007 cell, is divided by 100! e.g. 500 is displayed and stored as 5! I reinstalled the package but the problem persisted!
KF
Reply With Quote
  #2  
Old 01-27-2009, 04:49 PM
Usertell Usertell is offline
Novice
  
Join Date: Jan 2009
Posts: 1
Usertell is on a distinguished road
Default Dividing by 100
fkaramagi

That is weird, I'll ask the obvious first, did you run a reg clean before reinstalling?
Reply With Quote
  #3  
Old 01-30-2009, 02:52 PM
caholmes caholmes is offline Dividing by 100! Windows Vista Dividing by 100! Office 2007
Advanced Beginner
  
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
caholmes is on a distinguished road
Default Dividing by a 100 fix
In Options
  • Version 2003 - Tools >> Options >> Edit >> Untick Fixed decimals
  • Version 2007 - Office Button >> Excel Options >> Advanced >> Untick Automatically insert a decimal Point
That should fix the problem
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Other Forums: Access Forums

All times are GMT -7. The time now is 11:57 PM.

Contact Us - Privacy Statement - Top

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