Custom format in EXCEL

Sometimes you want to hide the cell error value: #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? Do this a few ways.

IN EXCEL easily format the font to display Superscript (x2) and subscript (Al2O3) characters. This can be done by highlighting part of the text in the cell and using the dialog box Format cells / Font (CTRL+SHIFT+F) to apply the desired font formatting. But this approach does not work if the cell is not a value but a formula. And yet, in some cases, there is a solution.

If You need to display the latitude or longitude in the format 56°54'31" (56 degrees 54 minutes 31 seconds) this is an example for You.