Thanks so much, Dennis! This is what I ended up using. This will display 2 decimal places for those numbers with no or 1 decimal, and will display however many more than 2 it might have:
(IFGT(MOD((PriceEach * 100),1),0, CTXT(PriceEach),FORMAT(PriceEach,'990.00'))) Karen In a message dated 12/19/2011 1:46:52 PM Central Standard Time, [email protected] writes: > (IFGT(MOD((`Price Each` * 100),1),0,FORMAT(`Price > Each`,'990.0000'),FORMAT(`Price Each`,'990.00'))) > > Dennis McGrath > Software Developer
