combining cells and keeping decimal format
 

I am combining 3 cells A1 B1 C1 with an x between them using this forumla:
=A1&" x "&B1&" x "&C1

A1's data is 07.00 (the entire column is formatted with Custom 00.00)
B1's data is 02.12 (same format)
C1's data is 02.12 (same format)

My DESIRED result is to have column D1 to look like this:
07.00 x 02.12 x 02.12

My ACTUAL result is looking like this:
7 x 2.12 x 2.12

Any suggestions for a rookie?

Thanks,
Bryan

combining cells and keeping decimal format
 

=TEXT(A1,"00.00")&" x "&TEXT(B1,"00.00")&" x "&TEXT(C1,"00.00")

"Bryan" wrote:

I am combining 3 cells A1 B1 C1 with an x between them using this forumla:
=A1&" x "&B1&" x "&C1

A1's data is 07.00 (the entire column is formatted with Custom 00.00)
B1's data is 02.12 (same format)
C1's data is 02.12 (same format)

My DESIRED result is to have column D1 to look like this:
07.00 x 02.12 x 02.12

My ACTUAL result is looking like this:
7 x 2.12 x 2.12

Any suggestions for a rookie?

Thanks,
Bryan

combining cells and keeping decimal format
 

Works like a champ !!!!!

Thank you so much.

"Toppers" wrote:

=TEXT(A1,"00.00")&" x "&TEXT(B1,"00.00")&" x "&TEXT(C1,"00.00")

"Bryan" wrote:

I am combining 3 cells A1 B1 C1 with an x between them using this forumla:
=A1&" x "&B1&" x "&C1

A1's data is 07.00 (the entire column is formatted with Custom 00.00)
B1's data is 02.12 (same format)
C1's data is 02.12 (same format)

My DESIRED result is to have column D1 to look like this:
07.00 x 02.12 x 02.12

My ACTUAL result is looking like this:
7 x 2.12 x 2.12

Any suggestions for a rookie?

Thanks,
Bryan