Referencing formatted cell in text

[claushojmark]

I'm having an issue with a formatted cell. I am trying write som text in a cell and using a cell reference to put a value in the middle of a sentence. It looks like this

Cells(122, 1).FormulaR1C1 = "This is text " & Range("B98") & " this is more text."

when it returns the cell value I get the unformatted version such as 5.0836272838939 instead of just 5.1. I tried to add .numberformat = "0.0" but it does not work. Any suggestions​

?

 

[Jonmo1]

Welcome to the board.

If the cell B98 is already formatted as you desire, try

Cells(122, 1).FormulaR1C1 = "This is text " & Range("B98").Text & " this is more text."


If the cell B98 is NOT already formatted as you desire, try

Cells(122, 1).FormulaR1C1 = "This is text " & Format(Range("B98"),"0.0") & " this is more text."