Truncating numbers

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top