How do you create a string literal in excel?

I have the following which needs to go into excel:

MovieID
-eodII2h

However, when I type it in, excel tries marking this up as a formula, and gives me:

#NAME?

Is there a way that I can skip the normal excel formatting on a cell, or if not, how to do a string literal in a cell?

1

1 Answer

Put a simple quote before the minus sign, like: '-eodllH

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

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

You Might Also Like