putting words after number imported

[JezLisle]

I have some code that imports a recordset from SQL Server and returns to my report and pastes the data into a set cell, I'm trying to add a word after the number imported how can I do this?

Please Login or Register  to view this content.

so I want to show in cell C12... 8 Months (so 8 would be returned from SQL Server and Months would be added afterwards)

How can I do this?

[rwgrietveld]

I prefer using the Cell format as the value remains a value and can be used as such later on.
Goto Format Cells, Custom and type ##" months"

[JezLisle]

The changing of the Format Cells works better, but if the answer is 0 then the zero (0) always disappears for some reason...

Why would this be?

[rwgrietveld]

Because the hashes will not display trailing zeros.

What you can do is use #0" Months"