In fact, you could use:

Format|Cells|Alignment tab|check shrink to fit.


Josette_N wrote:

Using MS Excel 2003 Professional Edition...
I've created a time and attendance worksheet where people can enter their
hours in increments of .25 for 15-minute intervals. I can't format the cells
to sum numbers without rounding it to the next highest number.

This causes problems such as:
2.50 + 7.25 = 9.80 (when it should read 9.75)

I know that I could add decimal points to the format (7.250) to correct the
problem, but this makes the sheet messy and cluttered, and my boss doesn't
like it. He wants it to read 8, not 8.000 when it's just a single number.

Can anyone assist? Thanks for your time! :-)

--

Dave Peterson