Thread
:
adding a cell in a text string
View Single Post
#
6
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
adding a cell in a text string
$1,026
="ddddddddddddd "& TEXT(O7,"$#,##0")& " dddddddd" &
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Seemore" wrote in message
...
On Aug 11, 9:45 am, "Don Guillett" wrote:
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.- Hide quoted text -
- Show quoted text -
Thanks. Int seemed to have gotten rid of the decimals. The number
however does not have any commas nor a $. The original cell is
formatted for currency and no decimals. I was able to overcome the $
issue by just adding it as text which works but commas would be very
helpful.
Thanks.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett