Formatting a number in a cell with text and number

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

 

[Joerg]

="Daily Average = "&INT(E2)

Cheers,

Joerg

 

[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

 

[Zilbandy]

="Daily Average = "&INT(E2)

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.

 

[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")

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