Unique problem

H

Howard

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.
 
M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top