Retain data format in results

[goble]

Hello

This should be pretty simple

Data inserted	Common Data	Formula
4.00	whatever	=A2&B2

I wanted the results in C2 to be : "4.00 whatever" but result will be "4 whatever".

The data inserted in A2 is with the ".00", it's not the excel cell format.

 

[Georgiboy]

Maybe:

=TEXT(A2,"0.00")&" " &B2

Is the cell formatted as text? as when i type 4.00 in a cell Excel makes it 4 unless i set the cell format.

 

[goble]

Perfect, that did the trick !