metuckness
New Member
- Joined
- Sep 4, 2013
- Messages
- 7
Hi,
I hope this is pretty simple. I have been asked to take over address for the county i works for and I am in the process of creating an Excel (2010) template sheet that the Secretary taking the address request calls can fill out information I need to verify and add an address.
I have two cells B33 and E33. B33 is for Longitude. All our reading in our county are going to lead off with -103 Longitude and I believe they all will do the same for 32 as our Latitude cell except it should not be in the negative.
I would like her to take the coordinate she gets always in the format as (Cell B33) -103 19.595 and Cell (E33) 32 58.744.
Instead of her having to actually type (in ta general formatted cell) -103 19.595 I would rather she just be able to type into the cell 103 19.595 and it would for mat the cell to display -103 19.595. The same for the Lat cell thought it should not display in the negative..
It's not really that I want to change the format of the displayed coordinates, but make it easier for her to enter them and they format to what I need. the perfect example is the telephone cell. I have a cell setup to take the reporting persons phone number. Well she just types in 5755559900 and the cell automatically formats it to (575)555-9900.
Could anyone explain how to format that long and latitude to accomplish this? Would be appreciated. So far most I have heard about is how to convert the format to something else or display it like this:
LONG:103°19'35.7"W LAT:32°58'44.64"N
SO what I am using it it for is when I punch in the DMS format into ArcGIS as -103 19.595 & 32 58.744 it converts it to the above and I do a search and bingo, all is good. But since the cell is just a general formatted filed the Secratary has to enter -103 19.595 each call etc.
Thanks!
Mitchell
I hope this is pretty simple. I have been asked to take over address for the county i works for and I am in the process of creating an Excel (2010) template sheet that the Secretary taking the address request calls can fill out information I need to verify and add an address.
I have two cells B33 and E33. B33 is for Longitude. All our reading in our county are going to lead off with -103 Longitude and I believe they all will do the same for 32 as our Latitude cell except it should not be in the negative.
I would like her to take the coordinate she gets always in the format as (Cell B33) -103 19.595 and Cell (E33) 32 58.744.
Instead of her having to actually type (in ta general formatted cell) -103 19.595 I would rather she just be able to type into the cell 103 19.595 and it would for mat the cell to display -103 19.595. The same for the Lat cell thought it should not display in the negative..
It's not really that I want to change the format of the displayed coordinates, but make it easier for her to enter them and they format to what I need. the perfect example is the telephone cell. I have a cell setup to take the reporting persons phone number. Well she just types in 5755559900 and the cell automatically formats it to (575)555-9900.
Could anyone explain how to format that long and latitude to accomplish this? Would be appreciated. So far most I have heard about is how to convert the format to something else or display it like this:
LONG:103°19'35.7"W LAT:32°58'44.64"N
SO what I am using it it for is when I punch in the DMS format into ArcGIS as -103 19.595 & 32 58.744 it converts it to the above and I do a search and bingo, all is good. But since the cell is just a general formatted filed the Secratary has to enter -103 19.595 each call etc.
Thanks!
Mitchell
Last edited: