 |
 | 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 / December 2005Excel 2003 won't let me change Xlabels from scientific notation
For some reason, when I type in bin bounderies for a histogram as: 0.0000 , 0.025, 0.050...... 0.175, 0.200 excel keeps changing them to exponential/scientific format, which not only takes up a lot of space, but just looks dumb. How can I force excel to show the labels the way I want? It sounds like the cells are formatted with scientific notation. Try selecting the cells, click Format> Cells, then go to the Number tab and select a more friendly format. Rgds, ScottO | For some reason, when I type in bin bounderies for a histogram as: | [quoted text clipped - 3 lines] | which not only takes up a lot of space, but just looks dumb. How can I | force excel to show the labels the way I want? |
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.