On Mar 10, 6:18*pm, Andrew wrote:
Hello,
I have one spreadsheet where I am trying to use CONCATENATE to combine
some text and a number.
The cell T6 contains "AT COST X "
The cell S7 contains a number 1.18
The cell S8 contains =CONCATENATE(T6,S7)

I get a #VALUE error on this, and I can't figure out why.

Any ideas?

I would like to add something to this...The worksheet I am working in
was originally developed in Excel 97. If I open a new workbook and
cut and paste this section into it, the code works fine.