How do I change the decimal place for a fixed length numeric value

[rrtraverse]

Current field value coming from sql table is numeric (6,2). I am using this field in an interface to another application that requires fixed length numeric (7,3). Changing the strings to fixed length has been easy enough, but numbers - not so much.

my formula is: if {table.colname} >= 1.0 and {table.colname}<= 150.0 then..

So, what would the correct syntax be for a fixed length number field AND to change the decimal place display on this number field.

Thanks

 

[synapsevampire]

If you are trying to state that you want it padded with zeros, then try:

totext({table.value},"0000000.000")

-k