View original (French)

Concatenate formula - display a digit after the decimal point even if it's zero

Solved
Steph -  
 Steph -
Hello,

Here is my problem. I have a very simple formula:

=CONCATENATE(M4;" x ";M4)

M4 = 1.0
I want the cell to display 1.0 x 1.0, but it shows 1 x 1

If M4 = 1.7, it displays 1.7 x 1.7, which is fine with me. But I can't get it to display the zero.

Thanks in advance!!!

2 answers

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     
    Hello,

    Try
    =CONCATENATE(TEXT(M4;"0.0");" x ";TEXT(M4;"0.0"))

    Regards
    0