Elanchezian R
Reputation: 97
how to store text starting with '+' in excel?
I need to store value like +a1.2.0 in excel cell but after storing it appears as #NAME? If I double click on it, then only the content appears. If I directly open the excel I should see the content not #NAME?. I am not able to produce it. Any suggestions?
I think this #NAME? appears because of formula it automatically created because of '+' sign before the content.
Upvotes: 0
Views: 1962
Answers (1)
Amar
Reputation: 124
You may write apostrophe ' before or change the format from General to Text.
Upvotes: 2
Related Questions
- In Google Sheets how do I enter the plus sign at the start of a field value?
- How to prefix Plus sign "+" before the number if the value is negative in Google Sheets or MS Excel?
- Add a plus sign to every word in a cell using Excel or Google SpreadSheets formula
- how to check if number begins with "+" in excel?
- How can I convert '+' character to a regular expression for REGEXMATCH in Google Sheets?
- How would I move a plus sign character (+) in excel from beginging of a word to a end?
- Using plus symbol + at the beginning of a formula
- Excel formula to separate " + " of two numbers in a cell
- Use text in a cell as plus and minus
- Find word plus additional characters in Excel cell