Can I make a formula in Excel to display result in same cell?

I am trying to make a cell in which the formula and the entry field are in
the same cell... In other words getting a formula to be locked in a cell to
where whatever info I put in the cell, the locked formula calculates the
entry number.

Not without using the f2 key to edit or a worksheet_change macro.

--
Don Guillett
SalesAid Software
donaldb@281.com
"Neiko" <Neiko@discussions.microsoft.com> wrote in message
news:340535D7-65B6-4852-9C60-66C6B29AFDAD@microsoft.com...
> I am trying to make a cell in which the formula and the entry field are in
> the same cell... In other words getting a formula to be locked in a cell
to
> where whatever info I put in the cell, the locked formula calculates the
> entry number.

Hi!

Maybe this might help:

http://tinyurl.com/bcakp

Biff

"Neiko" <Neiko@discussions.microsoft.com> wrote in message
news:340535D7-65B6-4852-9C60-66C6B29AFDAD@microsoft.com...
>I am trying to make a cell in which the formula and the entry field are in
> the same cell... In other words getting a formula to be locked in a cell
> to
> where whatever info I put in the cell, the locked formula calculates the
> entry number.