Loading Profile...
How do you escape a character in Excel?
I need to enter a number that starts with a zero and Excel isn't liking this. I know there's a way to escape a character and I know I've known how to do this in the past but I'm forgetting now.
I’m feeling spacey.
1 person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
-
Inappropriate?Try typing a ' before the number - it will tell Excel to treat it as text but you can still sort on it... won't work if you need to do a calculation on it though.
2 people say
this answers the question
-
Inappropriate?Perfect. I knew it was something simple like that but couldn't remember what. Thanks much.
I’m grateful
-
Inappropriate?old chinese proverb "...if you shift no work, or ctrl no work, or alt no work, or even combination no work, use special character and stop being lazy..."
