Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique problem
Hi everyone. I'm working with longitude and latitude (lots of data). In one
column, I have the letter N (for North), and in the next column, If have the longitude (37.680000) I need to combine the two (N 37.680000) while keeping the six place decimal. Does anyone have a suggestion. I've tried everything that I can think of without results. -- Howard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique problem
Howard,
You can do it a couple of ways and here are two A1=N B1=37.680000 Use =A1&TEXT(B1,"0.000000") or apply a custom format to b1 of "N" 0.000000 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Howard" wrote: Hi everyone. I'm working with longitude and latitude (lots of data). In one column, I have the letter N (for North), and in the next column, If have the longitude (37.680000) I need to combine the two (N 37.680000) while keeping the six place decimal. Does anyone have a suggestion. I've tried everything that I can think of without results. -- Howard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique problem
Thanks Mike for getting back so quickly. I'm sure this will do what I need.
-- Howard "Mike H" wrote: Howard, You can do it a couple of ways and here are two A1=N B1=37.680000 Use =A1&TEXT(B1,"0.000000") or apply a custom format to b1 of "N" 0.000000 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Howard" wrote: Hi everyone. I'm working with longitude and latitude (lots of data). In one column, I have the letter N (for North), and in the next column, If have the longitude (37.680000) I need to combine the two (N 37.680000) while keeping the six place decimal. Does anyone have a suggestion. I've tried everything that I can think of without results. -- Howard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique Problem? | Excel Programming | |||
Copy and Sort Unique Problem | Excel Discussion (Misc queries) | |||
List of values / unique problem | Excel Programming | |||
Unique problem with recorded macro | Excel Programming | |||
Problem with my Unique Number Macro...Help? | Excel Programming |