Concatenate Displays Too Many Decimals

  • Thread starter Thread starter DOUG
  • Start date Start date
D

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
 
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,"#")
 
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
 
Back
Top