Formatting cells for navigational degrees

imdg69

New Member
Joined
Aug 27, 2002
Messages
14
I am conducting site audits which require GPS readings to be taken and placed in Excel 2000 cells. No one I've spoken with knows how to have the numbers displayed with the degree character. Can this be done, and if so, how?

Can anyone help make this spreadsheet look more professional than just double spacing before the hours numbers?

Thanks
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Swamp Thing

Active Member
Joined
Aug 16, 2002
Messages
313
Or you could paste this into a standard module:<pre>Function Degree(St As String)
Degree = s & Chr(176)
End Function</pre>
Then type for example,<pre>=Degree(123)</pre> into a cell.
This message was edited by Swamp Thing on 2002-08-28 21:07
 

imdg69

New Member
Joined
Aug 27, 2002
Messages
14
Thanks for the info, but I don't think I gave enough info. I am on thr road so using a laptop without a number pad and using the "alt" key just creates a "beep". I am trying to format two cells to where I can just type in 8 numbers, and the cell formats it into the form " ##(degree symbol)##.###(feet symbol) ".
Example
82°41.989'
I was able to add the macro Swamp Thing
gave me which enabled me to create the cell I pasted above, but this is very time consuming.
Is there a way to format these cells so that anyone can open the workbook and just enter numbers into the cells and it come out looking like the example.
I'm sure for the pro's in here, it's a snap, but for the Excel beginner like me, it's real frustrating.
Oh, and after the macro was in place I used the formula " =82&Degree(2)&41.989&"'" ".
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690

ADVERTISEMENT

Use custom formatting. Enter this

##"º"##"."###'

This will display as 89º34.567'

HTH
This message was edited by lenze on 2002-08-30 12:54
 

gwkenny

Well-known Member
Joined
Aug 13, 2002
Messages
565
You could place the following as your custom number format:

##"°"##"."###"'"

It ain't pretty and I wouldn't want to do calculations off that, but if you just want the look this'll do it for you.

g-
 

gwkenny

Well-known Member
Joined
Aug 13, 2002
Messages
565

ADVERTISEMENT

Man, beaten to the punch again! And by a few seconds no less!!!

g-
 

imdg69

New Member
Joined
Aug 27, 2002
Messages
14
Thanks guys, but with custom formatting you need to be able to use hold the "alt" button while typing the numbers 0176 to insert the degree symbol. My laptop won't let me do that function.

I appriciate the help though, keep trying.
 

imdg69

New Member
Joined
Aug 27, 2002
Messages
14
By the way, pasting into the "type:" line of custom formatting isn't an option either. Maybe I can take my laptop to Best Buy and unplug a USB keybourd from a display without anyone saying anything? What do you think?

Anyway, it's turning out to be a good problem.
 

imdg69

New Member
Joined
Aug 27, 2002
Messages
14
GOT IT!!!

I had a brain fart.....just used the "ctrl" "V" function to paste into the formula. Wish I'd thought about that three days ago. Works like a charm. Thanks again.
 

Forum statistics

Threads
1,147,691
Messages
5,742,659
Members
423,746
Latest member
Joaogomes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top