number formatting 2

[ganjass]

CR 8

Hi I need to format numbers so that they are right justified with leading zero's to the length of 11 digits with no decimal place.

eg. 30.50 would be 00000003050
100.60 00000010060

Cheers

 

[nagornyi]

ToText({NumberField},'0000000000'}

 

[vidru]

Try this:

replicatestring("0", 11 - len(replace(totext({table.field),".","&quot)) + replace(totext({table.field}),".","&quot

-dave

 

[ganjass]

nargoyni cheers mate close but no cigar it does right justify the number but it forgets the number after the decimal,

vidru sweet as a nut it worked perfectly

 

[lbass]

Nagornyi's approach would work with the following modification:

totext({table.number} * 100, "00000000000&quot

-LB

 

[ganjass]

thanks all

Good effort!