Donate SIGN UP

Excel.

Avatar Image
Wraith | 12:44 Sun 20th Feb 2005 | Technology
5 Answers

When entering data into an Excel cell, how can I get it to accept + - * / as entries and not as a formula?

The reason I want this is because I have set up a small spreadsheet for my son to play on. In column A he enters his first number, column C his second number and in column B I want him to be able to enter + - * /

I have set the column has text or general, but excel still thinks that I'm entering a formula. 

Gravatar

Answers

1 to 5 of 5rss feed

Best Answer

No best answer has yet been selected by Wraith. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Put in the symbol i.e. + then press enter. Perhaps though it may be wise to show your son how Excel works and how to input a formula properly?
Question Author

Gandy, try it with / and see what happens. Also, sometimes it accepts +, but not always. Sometimes it thinks it's aformula.

entering a value and then pressing enter should always leave it on it's own and not change it to a formula, maybe ur using an older version of excel than us.
The / symbol is the defualt Excel menu key. To change this go to tools/options and select the Transition tab. Change the defualt Excel menu key to the tilde key (the button above your tab key). Click OK and you'll now be able to use the / symbol.
Question Author

Hi georgeous, I'm using Excel 2000 (9.0.2720).

Gandy, have reset the default menu key and / is now accepted as an entry on its own. Thanks.

Have also discovered that part of the problem was that I was using the cursor keys to move from cell to cell, instead of ENTER.

 

Thanks again.

1 to 5 of 5rss feed

Do you know the answer?

Excel.

Answer Question >>