Thread: How do I merge 2 cells to 1 when contents are numbers AND retain decimals
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote