On Aug 10, 4:05*pm, "Rick Rothstein"
wrote:
If this is a VB question (you posted your question in a programming
newsgroup), show us your code. If this is a worksheet formula question, then
show us your formula.

--
Rick (MVP - Excel)

"Seemore" wrote in message

...



I wanted to add a cell (formula) within a text string. *I found the
syntax but when I did it, the cells would leave values with decimal
points. *My original cells were formatted with no decimals (whole
numbers only) but inside the text string I get decimals and in some
cases 6 or more. *How can I get rid of the decimals?

Hopefully this made sense. *Thanks in advance for your help.- Hide quoted text -

- Show quoted text -



The string that i used is ="If you pay $Sheet3!$J$5&" over 15 years,
you will have paid a total of $"&Sheet3!L18&"." The first cell
gives me 2 decimals and the second gives me 9. I would prefer whole
numbers instead. I appreciate the help and will also seek the help of
the other group you mentioned.

Thanks again for your help.