Forum Discussion
Solved
Custom formatting of text to a number
Custom formatting of text like" 5+" 7=12... What format settings should I give to change 5+ to change it to a number so that after changing format settings, when I add 5 + 7. I should get the result...
Let do step by step. Enter 5 in G3, 7 in H3, and =G3+H3 in I3. It looks like
Select G3:I3 and copy to the next row, into G4:I4. You have the same. Now stay on G4, Ctrl+1, Number->Custom and type General "pounds" into the Type: bar
Click Ok
Same for H4
In I4 it could be
Please check in attached file.
In file there is no text "5 +". It is number 5 formatted such way. Click Ctrl+1 on cell to check.
- Thanks Sergei
But in excel when I add column with 5+ to 7, I am getting an error.It is not adding. I guess it is taking 5+ as text- Can you tell me what setting change should I do apart from General + in type
Please check the formula bar, that's number 5, nothing else. This "else" appears in the cell when you apply custom number format to it. To do that stay on cell, Ctrl+1, select Custom format and type General+ or whatever else you need. No special settings.
