 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / March 2008Why do my numbers keep going down decimal places?
Whenever I post any number in Excell 2002 it goes down exactly two decimal places and rounds. For example, I post 8 and it shows up as 0. Clicking the cell reveals that it has changed into 0.08. Please help! It's probably just a fixed decimal setting Click Tools > Options > Edit tab Uncheck "Fixed decimal" > OK should get things back to normal  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Whenever I post any number in Excell 2002 it goes down exactly two decimal > places and rounds. > For example, I post 8 and it shows up as 0. Clicking the cell reveals that > it has changed into 0.08. Please help! You need to format the column. Click the column, right click, format cells, then choose numbers, set the decimal place where you need it to be. > Whenever I post any number in Excell 2002 it goes down exactly two decimal > places and rounds. > For example, I post 8 and it shows up as 0. Clicking the cell reveals that > it has changed into 0.08. Please help!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.