is this possible?

[new2vba]

i have two columns:
=F2-B2
=E2-B2

i want another column that shows the values of both columns such as:

=F2-B2 (= "0")
=E2-B2 (= "1")

new column: "0 to 1"

 

[Kjuel]

Maybe the international setting, try:

=TEXT(H2;"0.00") & " to " & TEXT(I2;"0.00")

 

[new2vba]

Try

=TEXT(H2;"0,00") & " to " & TEXT(I2;"0,00")

The formatting works like Custom Number under the menu Format Cell.

this says formula contains an error and highlights the "h2"

ok, solved with changes to your punctuation:

=TEXT(h2,"0.00") & " to " & TEXT(I2,"0.00")

thanks Kjuel!
...and thanks Norie for the translation