Truncating numbers


G

Guest

When I export an Excel file to a text file, it truncates the numbers to 2 decimal place. How do I stop this? I am working with Latitude and Longitude values and need at least 4 decimals, but need it in text format.
 
Ad

Advertisements

G

Guest

Sounds like the format the number displays is more decimal places than the data itself. If this is the case, then the data has to be changed so that .25 is .2500 (for example)

Word has a better replace command than Excel. You could replace .^#^# with .^#^#00 to extend all 2 decimal numbers to 4

If your stuck in Excel, you would need to do it via a formula or function

Hope that helps
 

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