hidden formula

[xtrmhyper]

can i hide the formula?

i want if i have a formula in A1= sum(a2:a10)
i want to see the user is "hyper" in formula not =sum(a2:a10)

tnx in advance

godspeed

 

[Anne Troy]

If you want the user to see "hyper", why not just type Hyper? What's the
point of the sum formula if you can't see its result?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Bob Phillips]

Select your target cell
Go to Insert>Name>Define Name...
Add hyper as the names in workbook
Add =SUM(A2:A10) in the Refersto box
Exit

now just use

=Hyper