How do I merge 2 cells to 1 when contents are numbers AND retain decimals
 

how can I merge two numbers into one cell and retain the decimals on a
whole number:

if i have, say, two cells with 7.00 and 2.12 in them and I merge them,
in the merged cell i see 7, 2.12 -- what i need to see in the merged
cell is 7.00, 2.12. any help would be MOST appreciated.

thanks,
christy


--
huruta
------------------------------------------------------------------------
huruta's Profile: http://www.excelforum.com/member.php...o&userid=30930
View this thread: http://www.excelforum.com/showthread...hreadid=506050

How do I merge 2 cells to 1 when contents are numbers AND retain decimals
 

What you're attempting is to take 2 numeric cells and create a text
cell. Consequently, you need to tell Excel how to format the numbers.

Try this:

A1: 7.00
B1: 2.12
C1: =TEXT(A1,"0.00")&", "&TEXT(B1,"0.00")

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=506050

How do I merge 2 cells to 1 when contents are numbers AND retain decimals
 

Try:

=TEXT(D2,"##.00")&", "&TEXT(E2,"##.00")

--
HTH

Sandy

with @tiscali.co.uk


"huruta" wrote in
message ...

how can I merge two numbers into one cell and retain the decimals on a
whole number:

if i have, say, two cells with 7.00 and 2.12 in them and I merge them,
in the merged cell i see 7, 2.12 -- what i need to see in the merged
cell is 7.00, 2.12. any help would be MOST appreciated.

thanks,
christy


--
huruta
------------------------------------------------------------------------
huruta's Profile:
http://www.excelforum.com/member.php...o&userid=30930
View this thread: http://www.excelforum.com/showthread...hreadid=506050

How do I merge 2 cells to 1 when contents are numbers AND retain decimals
 

Sandy & Ron,

Both of your suggestions worked. Thank you so much. I tend to get
fixated on these types of problems and it just sucks up my day when I
should really be working on other stuff. Your prompt assistance and
useful solutions were truly appreciated!

All the best,

Christy


--
huruta
------------------------------------------------------------------------
huruta's Profile: http://www.excelforum.com/member.php...o&userid=30930
View this thread: http://www.excelforum.com/showthread...hreadid=506050