Format cells to read 22° 33'12" Latitude numbers

[Captain Randy]

Working with Excel 2007, to create a custom number format to handle,
Latitude numbers. In all of the helps I have read they say to do this and that. But it will not work.

I want to custom numbers in a row of cells so when I type in the number
223312 it should be in the cell as 22°33'12"..

Thank You in advance for any help.

 

[MisterExcellent]

Hello Captain Randy,

I'm using Excel 2003.
This works at 2003:

#.º##'##\"

 

[Captain Randy]

Hello Captain Randy,

I'm using Excel 2003.
This works at 2003:

#.º##'##\"

Thank You very much. I found that you way worked great once I dropped the . so this is how it works in 2007 ##°##'##\".

Thank You for your help.
Randy