Formula Problem

[mastahkevin]

I seem to have trouble w/ a particular formula. I am attempting to
round a number to the nearest tenth. No big deal...simple stuff if it
were to stop there. I have rounded the number which returns as a
decimal. I don't have trouble with any other number except when
dealing with a zero in the 10ths spot. When I add text to the formula
the decimal is not shown. Is there a way to have Excel first
determine whether I have a zero in the tenths column and if so, have
it show the decimal? Here's an example of the formula...

FORMULA RESULT
=ROUND(Battery!F30,0) 2.00

=ROUND(Battery!F30,0)& " Days" 2 Days

I want it to show 2.0 Days

Make sense? Thanks!

 

[Richard Schollar]

Hi

Try:

=TEXT(Battery!F30,"0") & " Days"

Richard

 

[Richard Schollar]

Sorry, should have been:

=TEXT(Battery!F30,"0.0") & " Days"

 

[Sandy Mann]

Make the rouded value text:

=TEXT(ROUND(F30,1),"0.0")&" Days"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[mastahkevin]

Sorry, should have been:

=TEXT(Battery!F30,"0.0") & " Days"










- Show quoted text -

The other kicker here is that it is not alwas 2.0 days. I only have
this problem if it's a 0 in the tenths spot. Would this still work?