Software

Ask something
Discussion Locked

Excel number cell

0 helpful
6 replies

by jsarinana

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'd like to call out a number in degree, minutes and second in Excel 2000, example: 37?33?12?
any suggestions

6 replies

by kees.valkenswaard

I have no idea how you enter the numbers. Suppose that you enter as 6 or more digits.
Use the follwing custom formatting:
00"?"00\"00'
This will give at least two digits for degrees.
The high circle [for degrees] you have to look up in the symbols list, copy and paste.
If you want to enter the numbers different, you should specify howe you enter.
In this example the number 12345 would be represented as 01?23"45'
1203430 as 120?34"30'

Good luck

by dklippert

Here are the instructions for working withe Degrees:

www.cpearson.com/excel/latlong.htm

BTW: the code for the degree symbol (?)is ALT+0176 (use the keypad for the numbers).
If you're going to do it right you'll also want to use a prime markrather than an apostrophe.

This discussion is closed to new replies.