On Jan 16, 9:36*pm, Ron Rosenfeld wrote:
On Mon, 16 Jan 2012 11:44:35 -0800 (PST), Yugi Gokavarapu wrote:
Hello There,

When I *write User Defined Function as below and use it, it returns
the output in the function argument dialouge box, but the out put is
not shown in the cell I wanted, instead I still see the input function
with arguments.

Function test(num)
* *Select Case num
* * * * Case Is 0
* * * * * * * test = "Positive"
* * * *Case Is = 0
* * * * * * * test = "Zero"
* * * *Case Is < 0
* * * * * * * test = "Negative"
* *End Select
End Function

Your help is appreciated!!

And if that is the problem, to correct it, FIRST change the cell format to General; THEN edit the cell. *You don't need to change anything. *Just put your cursor at the end of the formula in the function bar; or open the dialog box, and hit <enter

Ron,

Thank you for your swing into this!

I have changed the cell type to General, and THEN edit the cell. I
see cell value as FALSE. Whereas I see the right output of function in
the function argument box.
Also, I noticed that when the menu Formulas - Show formula option
enabled, I see the formula in the cell. When I disable to Show
Formula, I see FALSE.

Any suggestions?