0

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!

5

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

4

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)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.