Does anyone know how to enter latitude and longitude in a spreadsheet, preferably in a manner that the figures can be manipulated? We have a ton of charts for all over Asia that we are going to inventory. We figured that we would put them on a spreadsheet (EXCEL). By entering the latitude of the top and bottom and the East and West longitudes, we should be able to quickly see the areas for which we have charts. Finding a way to do this that looks good and is easy is eluding us. We have messed around with the cell-formatting menu to no avail. Help! Maurice & Louise-Ann AKAMA

You might try the time format xx:xx:xx. In Excel it will correctly calculate differences and sums. It will allow you to enter an invalid number, say, 36:75:30, but will not allow it to calculate since it treats such an invalid entry as text. At 07:48 PM 8/18/99 +0800, Maurice Nunas wrote: >Does anyone know how to enter latitude and longitude in a spreadsheet, >preferably in a manner that the figures can be manipulated? > >We have a ton of charts for all over Asia that we are going to inventory. >We figured that we would put them on a spreadsheet (EXCEL). By entering the >latitude of the top and bottom and the East and West longitudes, we should >be able to quickly see the areas for which we have charts. > >Finding a way to do this that looks good and is easy is eluding us. We have >messed around with the cell-formatting menu to no avail. > >Help! > >Maurice & Louise-Ann >AKAMA > > > > Frank H. Timpano ftimpano@richmond.infi.net