Formatting a number in a cell with text and number

Z

Zilbandy

I have a cell with the following entered in it:

="Daily Average = "&E2

The value of E2 diplays with all the decimal points showing. I need to
format the value of E2 to display with no decimal points showing, such
as 4532 instead of 4532.23764....

Can I specify the format to be used in the cell equaion?
 
J

Joerg

Ahh..forgot to tell you: INT always rounds down, so -5.1 results in 6 and
5.9 results in 5
If you need to round to nearest integer you may want to use ROUND or
something like
="Daily Average = "&TEXT(E2,"0;-0")

Cheers,

Joerg
 
Z

Zilbandy

="Daily Average = "&INT(E2)
Click to expand...

Thanks, that worked, but didn't round the number. It did give me the
clue to look in math functions and I found the ROUND function. Thanks.
:)
 
Z

Zilbandy

Ahh..forgot to tell you: INT always rounds down, so -5.1 results in 6 and
5.9 results in 5
If you need to round to nearest integer you may want to use ROUND or
something like
="Daily Average = "&TEXT(E2,"0;-0")
Click to expand...

Thanks. I used the ROUND function. It's all solved now. :)
 
Top