Erasing a Formula?
 

Everytime i enter a number in excel does it automatically create a formula
for it? For example, i am entering -3 - 4 and it gives me the answer after i
move to the next cell or when i hit enter, but all i want is JUST to enter
and see -3 - 4 on the screen and i don't want it to give me any answer. if it
makes any sense, please answer. thank you

Varan

Erasing a Formula?
 

format the cell to text or type an apostrophe and then the number ie '-3-4
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Varan27" wrote:

Everytime i enter a number in excel does it automatically create a formula
for it? For example, i am entering -3 - 4 and it gives me the answer after i
move to the next cell or when i hit enter, but all i want is JUST to enter
and see -3 - 4 on the screen and i don't want it to give me any answer. if it
makes any sense, please answer. thank you

Varan

Erasing a Formula?
 

Hi,

Right click on the cell you want to use choos format cells choos the tab
"number" then choos text and then click OK then you can enter -3-4 and see it.

Thanks,

--
Farhad Hodjat


"Varan27" wrote:

Everytime i enter a number in excel does it automatically create a formula
for it? For example, i am entering -3 - 4 and it gives me the answer after i
move to the next cell or when i hit enter, but all i want is JUST to enter
and see -3 - 4 on the screen and i don't want it to give me any answer. if it
makes any sense, please answer. thank you

Varan