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

#1 October 1st, 2005, 09:42 PM

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.

#2 October 1st, 2005, 10:22 PM

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

--
Don Guillett
SalesAid Software

"Neiko" wrote in message
...
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.

#3 October 1st, 2005, 10:36 PM

Hi!

Maybe this might help:

http://tinyurl.com/bcakp

Biff

"Neiko" wrote in message
...
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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I NEED HELP with the SPELLNUMBER Function	vag	Worksheet Functions	0	June 21st, 2005 08:17 AM
PLEASE HELP with the SPELLNUMBER function	vag	Worksheet Functions	0	June 16th, 2005 01:33 PM
EXCEL:NUMBER TO GREEK WORDS	vag	Worksheet Functions	1	June 15th, 2005 05:57 PM
How do I display the RESULT of a formula	Poor microsoft user	New Users	3	April 27th, 2005 03:18 PM
Inserted Excel Worksheet won't display all columns	Andy	General Discussion	1	September 30th, 2004 01:18 PM