All spreadsheet formulas MUST begin with the "=" character (as originally
designed by MS), however they
expanded it to accomodate the Lotus 1-2-3 users by
granting/allowing the "+" or "-" signs to enter formulas.

Concatenation is a formula since it starts with the "="
character. NO MATTER what, if a cell is formatted
as Text the character "=" in the first position becomes
text, NOT the mathmatical - operator "=".

Does that help?


"jbenet" wrote in message
...

Thanks you two guys. Yes, you are right but doesn't it seem odd that a
text manipulation function doesn't work with a result field
pre-formatted as text!?
John


--
jbenet
------------------------------------------------------------------------
jbenet's Profile:
http://www.excelforum.com/member.php...o&userid=29531
View this thread: http://www.excelforum.com/showthread...hreadid=492297