I need to convert a number to a text string that is appended to a text file. If I convert the number 9.12 it comes out as the correct number 9.12 If I convert the number 9.00 it comes out as 9 when in fact I need the number 9.00

Can you help me with this?

Thanks

FileMaker Version: 6

Platform: Windows 95/98

Hi Ken,

Try this

Int (Round (NumberField , 2)) & "." & Right (Round (NumberField ,2) * 100,2)

HTH

Lee

Thanks so much Lee. It works like a charm. I have one more question. If the text format is supposed to have 11 characters for the output number then how do I get the proper number of spaces in the output to balance this out? Eg. if the number is 123.45 I need the output to be -----123.45 where - is a blank. Or if the number is 123456.78 I need the output to be --123456.78.

Thanks again.

Ken

Right( "        " & Int(Round(NumberField , 2)) & "." & Right(Round(NumberField ,2) * 100,2), 11 )  

There are 8 spaces in that, btw.

Thanks again for the Help!!!