Number Format: 1.0 = "0000100000"
<p>I have a task to deliver a numeric/decimal value as part of a fixed length text file.  These values will take the following form:</p>

<p>10 chars, w/last 5 chars representing the decimal portion of the string.  These will all be positive numbers.</p>

<p>A few examples:</p>

<p>0.123 = "0000012300"
1.0 = "0000100000"
123.456 = "0012345600"
234 = "0023400000"</p>

<p>The numeric data resides in an Access database formatted as numbers (double).</p>

<p>My current thought is:</p>

<ol>
<li>Retain the orignal numeric data in one table</li>
<li>Convert to TEXT strings via query, save to a second table</li>
<li>Export to a fixed width flat file using MSAccess export function</li>
</ol>

<p>Can anyone suggest a reasonable approach to produce the necessary 10 character TEXT conversion?  </p>

<p>Thanks!</p>