A formatting quandry...

I can't quite figure out why this is occuring.

I have a simple formula that is behaving oddly.

the formula executes simple division and then adds a label.

As follows,

Please Login or Register  to view this content.

Problem is, even though I have the cell format set to "number" with "2" decimal places I still get 16 decimal places!

You can see the result in the attached file.

Funny thing is, when i remove the label the resultant reverts back to the proper format!

???

Anybody know of a way to add the label without blowing the format?

Try this:

Please Login or Register  to view this content.

Originally Posted by StephenR

Try this:

Please Login or Register  to view this content.

Thank you very much Stephen, that did the trick!

Here's another way I like.....

=FIXED(48-D2)&" hours"

Or use the formula =48-D2 and format as 0.00"hours". That way it's still a number.

Originally Posted by shg

Or use the formula =48-D2 and format as 0.00"hours". That way it's still a number.

This is not an option for me, or at least I don't know how to accomplish this feat.

Format > Cells > Number > Custom, 0.00"hours"

Originally Posted by shg

Format > Cells > Number > Custom, 0.00"hours"

Got it!

Works great, thanks for your help!