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
[email protected]
[email protected] with @tiscali.co.uk


"huruta" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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