AnsweredAssumed Answered

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

Question asked by henryoswald on Aug 20, 2009
Latest reply on Aug 21, 2009 by RickWhitelaw

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!

Outcomes