The CONCATENTION works fine for me in XL97...........what version are you
using, and what typical values do you have in B7 and C7?

Vaya con Dios,
Chuck, CABGx3


"Pa Maher" wrote in message
...
A report lists in 2 columns an account number and a sub-account number as
numeric fields.
I want to concantenate these fields. when I use "=CONCATENATE(B7,C7)" I
get
a #VALUE! error message. If I place a ' infront of the numbers in B7 and
C7
then it works fine. Is there any way to use the concantenate function
without inserting the ' infront of a few thousand fields? Changing the
cell
format to text has not worked.
Thanks