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 and i don't want it to give me any answer. if it makes any sense, please answer. thank you
2007-03-27 07:30:00 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
right click on the cell in question and format the cell as text. then put in what you want for example -3-4.
2007-03-27 07:34:58 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Hi,
You will have to use VBA to do this so your Calculation appears in the same cell as you add the data, Use after cell Update function. hope this makes sense.
2007-03-27 14:35:42 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Put a ' in from of it so reads '-3
Its trying to help!
2007-03-27 14:41:37 · answer #3 · answered by robert m 7 · 1⤊ 0⤋