ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formating a cell (https://www.excelbanter.com/excel-discussion-misc-queries/177804-formating-cell.html)

UniStudent Coll[_2_]

formating a cell
 
can you format a cell so that it is in degrees ie 180° this is because i need
to subtract to bearings from another.

FC

Gary''s Student

formating a cell
 
Format Cells... Number Custom General"° "
--
Gary''s Student - gsnu200770


"UniStudent Coll" wrote:

can you format a cell so that it is in degrees ie 180° this is because i need
to subtract to bearings from another.

FC


Gord Dibben

formating a cell
 
See Chip Pearson's site for working with degrees, minutes, seconds and doing
arithmetic with same.

http://www.cpearson.com/excel/latlong.htm


Gord Dibben MS Excel MVP

On Mon, 25 Feb 2008 10:13:00 -0800, UniStudent Coll
wrote:

can you format a cell so that it is in degrees ie 180° this is because i need
to subtract to bearings from another.

FC




All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com