### Title

Fixing Number lengths - adding 0's to the start of a number

### Post

I need to export some data so all the numbers are the same length (6 digits),

i.e. 8.348 beomes 008.348,

79.648 becomes 079.648,

and 148.432 stays at 148.432

Does Anyone know a way of doing this without scripting? (its 201,596,725 records!)

many Thanks!

Create a calculation (result is text) and export the calculation instead. It might look like:

SerialIncrement ( "000" ; Div ( num ; 1 ) ) & Mod ( num ; 1 )