display result and hide macro formula

[acounter2]

Hi everyone,

Excel 2003.
I have been struggling for an hour how to hide a number to text macro in a way that only macro result is displayed in a cell.
Any ideas?

(I have one 2-3 years old xls, where I have managed with task, but now can't figure out how and how to unhide the macro
Can it be password protected somehow?

Thanks!

 

[mikerickson]

If you select a cell and run your sub valem, the formula you see is the formula that is in the cell.

That is the formula that is in the cell, there is no other hidden formula.