Chuck and Pa

Excel 2003............

No problem with =B7&B8 with the sample given below.

Returns 12345610 as text

=CONCATENATE(B7,B8)

Returns 12345610 as text

=(B7&B8)*1 returns 12345610 as numeric


Gord Dibben MS Excel MVP

On Tue, 16 Jan 2007 19:47:32 -0500, "CLR" wrote:

I dunno........the numbers CONCATENATE fine for me on this, another 97
machine. I don't have 2003, so maybe someone with it will reply as to how
it reacts for them.........sorry I could not be of more help.

Vaya con Dios,
Chuck, CABGx3




"Pa Maher" wrote in message
...
XL 2003, example
B7 = 123456
B8 = 10
CONCATENTION works fine if I insert the ' in front of the number

"CLR" wrote:

The 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