Excel 2003 won't let me change Xlabels from scientific notation

C

CVb

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

ScottO

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top