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

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

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