Text Formatting for Lat/Long applications

M

mgs

I utilize a program that needs Lat and Long values to be as such ##.###.###
for data syncing purposes. I can not format the cells to maintain this
structure without turning them into 'text' format. I have thousands of data
entries and need to steamline this process rather than doing them one by one.
Is this possible?
 
L

Luke M

You could try the custom format of:

##"."###"."###
or
00"."000"."000

if you want to force a zero-fill. You can now input your data as a number,
and it should display correctly.
 

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

Similar Threads

ASK Field Formatting 1
Cut some of the data in a cell and move to the neext cell 4
CSV->Excel Data Problem 1
Conditionally formatting text and numbers differently 1
Importing Long Numbers as Text cells 1
Find/Replace Numbers stored as Text drops zeros 1
Formatting cells to only upper case 5
Using Format Painter with Conditional formatting 0

Top