Combining values problem

[JonRowland]

Hi,
I have two variables declared as string and I am combining them using
</code>
Cells(lngrow, 27) = strSRowA & "," & strSRowB
</code>

So I have one cell as 1154 the second as 1155 I wish to combine as <b>1154,1155</b> but the value in the cell displays as 11,541,155 and is stored in the cell as 11541115.

What do I need to do to get the correct value stored & displayed in the cell?

 

[mart37]

Cells(lngrow, 27) = strSRowA + strSRowB / 1000
Cells(lngrow, 27).NumberFormat = "0.0000"

 

[JonRowland]

Not what I wanted as formatted incorrectly and does stored what I want in the cell. But jogged my memory.

<code>
Cells(lngrow, 27).NumberFormat = "@"
Cells(lngrow, 27) = strSRowA & "," & strSRowB
</code>

Hey presto get what I want
Cheers