RE: Fighting with NumberFormat

2001-03-20 Thread Jason E Miller
Just try this with your number format #NUMBERFORMAT(1234.1200,'9.99')# Or if its always going to be a Money amount #DOLLARFORMAT(1234.1200)# Hope this helps. Jason E Miller Computer Consultants Unlimited http://www.computercu.com Brainbench Certified Cold Fusion Developer 4.5

Re: Fighting with NumberFormat

2001-03-20 Thread Jim McAtee
Your results are slightly different than what I get when I test it. I get the string * if I try to stuff 1234.12 into a five character mask. Make sure you have a sufficient number of mask characters to the left of the decimal point. You can always LTrim() the results to eliminat the