I am trying to get an export out to an AGS file where the Depth is always a set number of decimal places, eg 0, 0.15 and 1.2 would be: 0.00, 0.15 and 1.20 respectively.

I have attempted a few things. 

Firstly setting the GEDTS export to a function call like: Format(Top_Depth,'#.00')

I also altered the Access DB AGS.mdb table as well: setting the field format to a Decimal number with a preset Format and decimal place precision. 

Neither of these have forced the exported number to the set number of decimals, although they are correctly rounding and setting when the number is larger. 

Any thoughts on how this might be achieved? 

JKW