Inserting two cell values into a new cell + text
 

I am likely making this much more difficult than it needs to be...

I need to take the numeric values from two cells and insert them into a
new cell in this format: "898 - 1398". Where 898 and 1398 are numeric
values generated by a formula and are subject to change.

What I have is: =VALUE(A1)&" - "&VALUE(A2)
but the result gives me one or more decimal places in each number
result which I know is a result of the string concatination process.

My question is: How can I rewrite this cell's formula to zero out the
decimal entries form the source cells which is hidden from view due to
its superfluous nature, but makes its way into my string result?

Thanks for the help,
I know I am the N00bish


--
mmednick
------------------------------------------------------------------------
mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404
View this thread: http://www.excelforum.com/showthread...hreadid=491155

Inserting two cell values into a new cell + text
 

=TEXT(A1,"0")&" - "&TEXT(A2,"0")

--
Kind regards,

Niek Otten

"mmednick" wrote in
message ...

I am likely making this much more difficult than it needs to be...

I need to take the numeric values from two cells and insert them into a
new cell in this format: "898 - 1398". Where 898 and 1398 are numeric
values generated by a formula and are subject to change.

What I have is: =VALUE(A1)&" - "&VALUE(A2)
but the result gives me one or more decimal places in each number
result which I know is a result of the string concatination process.

My question is: How can I rewrite this cell's formula to zero out the
decimal entries form the source cells which is hidden from view due to
its superfluous nature, but makes its way into my string result?

Thanks for the help,
I know I am the N00bish


--
mmednick
------------------------------------------------------------------------
mmednick's Profile:
http://www.excelforum.com/member.php...o&userid=29404
View this thread: http://www.excelforum.com/showthread...hreadid=491155

Inserting two cell values into a new cell + text
 

Hi

=A1 & " - " & A2

Arvi Laanemets


"mmednick" wrote in
message ...

I am likely making this much more difficult than it needs to be...

I need to take the numeric values from two cells and insert them into a
new cell in this format: "898 - 1398". Where 898 and 1398 are numeric
values generated by a formula and are subject to change.

What I have is: =VALUE(A1)&" - "&VALUE(A2)
but the result gives me one or more decimal places in each number
result which I know is a result of the string concatination process.

My question is: How can I rewrite this cell's formula to zero out the
decimal entries form the source cells which is hidden from view due to
its superfluous nature, but makes its way into my string result?

Thanks for the help,
I know I am the N00bish


--
mmednick
------------------------------------------------------------------------
mmednick's Profile:
http://www.excelforum.com/member.php...o&userid=29404
View this thread: http://www.excelforum.com/showthread...hreadid=491155

Inserting two cell values into a new cell + text
 

=ROUND(A1,0)&" - "&ROUND(A2,0)

--
Regards,
Dave


"mmednick" wrote:


I am likely making this much more difficult than it needs to be...

I need to take the numeric values from two cells and insert them into a
new cell in this format: "898 - 1398". Where 898 and 1398 are numeric
values generated by a formula and are subject to change.

What I have is: =VALUE(A1)&" - "&VALUE(A2)
but the result gives me one or more decimal places in each number
result which I know is a result of the string concatination process.

My question is: How can I rewrite this cell's formula to zero out the
decimal entries form the source cells which is hidden from view due to
its superfluous nature, but makes its way into my string result?

Thanks for the help,
I know I am the N00bish


--
mmednick
------------------------------------------------------------------------
mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404
View this thread: http://www.excelforum.com/showthread...hreadid=491155

Inserting two cell values into a new cell + text
 

The solutions with the TEXT and ROUND functions and a second variable
set to 0 both seem to work, but they cut out the comma I need in
numbers grater than one thousand, any thought on how to keep comma
format?

The N00bish


--
mmednick
------------------------------------------------------------------------
mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404
View this thread: http://www.excelforum.com/showthread...hreadid=491155

Inserting two cell values into a new cell + text
 

bump

the n00bish


--
mmednick
------------------------------------------------------------------------
mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404
View this thread: http://www.excelforum.com/showthread...hreadid=491155

Inserting two cell values into a new cell + text
 

=TEXT(A1,"#,#")&" - "&TEXT(A2,"#,#")

--
Regards,
Dave


"mmednick" wrote:


bump

the n00bish


--
mmednick
------------------------------------------------------------------------
mmednick's Profile: http://www.excelforum.com/member.php...o&userid=29404
View this thread: http://www.excelforum.com/showthread...hreadid=491155