How do I alway keep a .0 showing, on round numbers

[richard11153]

I have a formula that shows "two cells numbers" in one new cell with spaces between, (see below)
but when I enter a round numbers it drops the .0 I want to keep it as a .0 The formula I have is below for
the two cells. I take the numbers from (cells B8 and C8) and put them both in one cell with spaces.

Cell B8 C8 Formula I'm using to get both numbers to show in one cell is
2.0 2.1 =B8&" "&C8

If the number in either cell is 1.2, or 1.3, it is fine. But if the number is 2.0, it drops
the .0 from the cell showing both numbers. I need it to always show the .0 (or whatever)
whether it be a .1, .2. or .0

Can someone help me. I am a basic excel user, so the formula would help.

Thanks in advance

[Norie]

Try this.

Please Login or Register  to view this content.

[richard11153]

Works, good. Thank You!!!