 |
 | 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 / New Users / April 2007Number format still uses decimal point
I have Excel 2002 SP3 and when I format cells to use numbers all numbers show up with a decimal and then are rounded up. For example. I want to put inventory numbers in column A such as number 394. The result is that the number shows up in the formula bar as three POINT nine four and in column A as a 4. Any help would be appreciated. Do you have fixed decimal turned on? Check Tools/Options/Edit - uncheck fixed decimal. > I have Excel 2002 SP3 and when I format cells to use numbers all numbers > show up with a decimal and then are rounded up. For example. I want to put > inventory numbers in column A such as number 394. The result is that the > number shows up in the formula bar as three POINT nine four and in column A > as a 4. Any help would be appreciated. FANTASTIC!!!! Thank you SO much for the help. God Bless all that help those of us with problems. Do you have fixed decimal turned on? Check Tools/Options/Edit - uncheck fixed decimal. "BecknRoos" wrote: > I have Excel 2002 SP3 and when I format cells to use numbers all numbers > show up with a decimal and then are rounded up. For example. I want to put > inventory numbers in column A such as number 394. The result is that the > number shows up in the formula bar as three POINT nine four and in column > A > as a 4. Any help would be appreciated. You're most welcome. Glad to help. > FANTASTIC!!!! Thank you SO much for the help. > God Bless all that help those of us with problems. [quoted text clipped - 11 lines] > > A > > as a 4. Any help would be appreciated. |
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.