Forum Discussion
Custom formatting of text to a number
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.
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
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.
- I want to understand the solution given in this excel...
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.
- I know...... it comes like that in this excel. But when I do it in my excel, and I do the same settings...(General+), I am getting 5+ in formula bar, not 5... I am not understanding where am I wrong.