Cell format for degrees and minutes

Honestly, were I you, I would just do a search here for FORMAT DEGREES MINUTES SECONDS. (Just be sure to search for ALL terms). You'll find that you pull up plenty of good discussions on the subject.

I did do a search before posting and tried again with your suggestion and still did not find anything relevant to this.

I am not sure that this can be done with a custom format because the user will have to enter three numbers perferably separated by spaces. This idea is built into excel for time.

Here is the solution:

Make six columns which represents, for example, Cell A1 enter degree number 86, Cell B1 for symbol of degrees click instert and click symbol to find the degree sign or press and hold ALT 0176, Cell C1 enter the minute number 35, Cell D1 enter the minute sign " ' ", Cell E1 enter second 49, and last Cell F1 enter the second sign " " ". So now, we will create like the format that you've expected: At Cell H1, here is the formula: enter =CONCATENATE(A1,B1,C1,D1,E1,F1), then it will apear like this: 86°35'49"