Concatenate Displays Too Many Decimals

[DOUG]

How do I hide the decimals in a cell containing a concatenation of text and a
reference to another cell? The other cell has a calculated amount, but
displays no decimals. The concatenated cell, with sentence text and the
referenced number from the other cell displays ten decimals. I do not need
to display them.

'Suggestions?

DOUG ECKERT

 

[Shane Devenshire]

Hi,

Two ways at least -
1. Remove the decimals from the original cell using a formula not
formatting, for example suppose cell A1 is the cell your concatenated formula
refers to and reads =SUM(B1:B100)
modify this to
=ROUND(SUM(B1:B100),0)
Then the concatenation formula will display no decimals.

2. Use the TEXT function in the concatenation formula, for example
="This is the Monthly Totals:"&TEXT(A1,"#")

 

[DOUG]

Gary's Student and Shane: Thanks. What I did instead was to insert the
FIXED function in place of the TEXT function in the concatenated statement.
It took me quite a while to stumble across this jewel. (GS, I had tried your
fix on my own, or something almost like it, but it did not work. Maybe my
quotations were off, although they seemed to be correct).

DOUG ECKERT