Concatenate function not working for me

[gerry.lisa]

I'm using Insert>>Function>>Concatenate and using the wizard

text 1 I'm clicking on the first cell I want to concatenate L2

text 2 I'm typing in ", " (without the quotes)

text 3, I'm clicking on the 2nd cell I want to concatenate M2

then enter

I'm getting =CONCATENATE(L2,", ",M2) in N2 as opposed to "text in
first cell, text in second cell"

What am I doing wrong?

....Lisa XL03

 

[PCLIVE]

Check that your cell is not formatted as text.
Right-click cell, Format Cells- Number tab. Set to General.

HTH,
Paul

 

[gerry.lisa]

That did it Paul!
Thanks!!

....Lisa

Check that your cell is not formatted as text.
Right-click cell, Format Cells- Number tab. Set to General.

HTH,
Paul