ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel 2003 won't let me change Xlabels from scientific notation (https://www.excelbanter.com/charts-charting-excel/62379-excel-2003-wont-let-me-change-xlabels-scientific-notation.html)

CVb

Excel 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?


Bernard Liengme

Excel 2003 won't let me change Xlabels from scientific notation
 
reformat the cells?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"CVb" wrote in message
oups.com...
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?





All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com