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

[huruta]

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

 

[Ron Coderre]

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

 

[Sandy Mann]

Try:

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

--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[huruta]

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