CONCATENATE expects TEXT operands. If a cell contains a number (rather than
a numeric value stored as text) you must use the TEXT(number,format) function
to convert it to text. e.g. TEXT(A2,"0")

"Ken Wright" wrote:

A1= abc
A2=123
A3= =A1&A2 = abc123

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JSS" wrote in message
...
I am trying to use the CONCATENATE function in Excel 2002. In the help
section is shows using a cell with a number only. When I include a number
cell I get a #value error. How can I use a number with this function?
Help!! Thanks