You wouldn't need it for "regular" formulas, because they're numbers
calculating numbers.

As I said, you used a Text parsing formula on numbers, forcing a Text
return.

=MID(E6,5,4)*1
=MID(E6,5,4)+0

Would have produced the same results

Use of the unary is just easier and quicker.

Check out this link of John McGimpsey:

http://www.mcgimpsey.com/excel/formulae/doubleneg.html

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Delaina" wrote in
message ...

Thanks-the number one did the trick. I know this may be a stupid
question-but if you put the hyphens infront of any formula will it
produce numbers? Is there anywere on the web little tips like that are
posted..?
Thanks again!


--
Delaina
------------------------------------------------------------------------
Delaina's Profile:
http://www.excelforum.com/member.php...o&userid=24151
View this thread: http://www.excelforum.com/showthread...hreadid=392324