G
Guest
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
=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