1

I'm trying to enter, "-0.0028 (204)" into a cell in excel, but it keeps attempting to evaluate this (non-)expression as, "=-0.0028*(204)". This occurs even when I set the cell format to, "General". Any suggestions? Thank you!

3 Answers 3

6

Use the single quote ' before whatever you're entering.

5

Format the cell as Text

or

precede it with an apostrophe

or

enter it as a formula:

="-0.0028 (204)"
1

Enter an apostrophe at the beginning of the cell

'-0.0028*(204)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .