Thread
:
adding a cell in a text string
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
adding a cell in a text string
try int(rng)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Seemore" wrote in message
...
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett