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
|