Truncating decimal places

[Greymane]

When I export a file (from Access or Excel) with a
decimal value (in this case Lat. and Lon. values) to a
text file, it truncates the decimals to two places. How
do I stop this? It works fine if I export as text values.

 

[Trevor Shuttleworth]

The decimal places are probably there, just not displayed. Select the cells
and either click on the icon on the toolbar to increase the decimal places
or change the formatting - Format | Cells... | Number tab | Number and
increase the Decimal places.

Regards

Trevor