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.
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.
- Thankyou so much Sergei.... My issue is resolved... Thanks a bunch
- Your explanation was really helpful
Aarush1950 , you are welcome
- Thankyou Sergei