Hello!
I am looking for a custom cell format, that turns the following coordinate format:
Into this format:
I was going to learn, how to create custom cell formats, but did not find relevant data on this subject.
I am going to use it on different excell documents, so I need it to be an easy to access, easy on use tool.
I am a newbie to this "advanced" use of excell, but I'm willing to learn it, please don't be harsh on me!
thanks!
(I'm using the 2016 office, if this matters)
I am looking for a custom cell format, that turns the following coordinate format:
19.1258333333333° ; 47.4686111111111° [Long - Lat -WGS 84-] |
019E07 33 ; 47N28 07 |
I am going to use it on different excell documents, so I need it to be an easy to access, easy on use tool.
I am a newbie to this "advanced" use of excell, but I'm willing to learn it, please don't be harsh on me!
thanks!
(I'm using the 2016 office, if this matters)