Jun 17 2021 06:57 AM
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 as 12.. It is done in the file. But when I do on my own excel, I don't get the correct answer
Please note... this should be done by changing custom format settings
Jun 17 2021 07:04 AM
In file there is no text "5 +". It is number 5 formatted such way. Click Ctrl+1 on cell to check.
Jun 17 2021 07:08 AM
Jun 17 2021 07:13 AM
Jun 17 2021 07:18 AM
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.
Jun 17 2021 07:21 AM
Jun 17 2021 07:22 AM
Jun 17 2021 07:44 AM
SolutionLet 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.
Jun 17 2021 01:51 PM
Jun 17 2021 07:44 AM
SolutionLet 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.