Hi Wendy
You can use FormatNumber() to format your variable before you produce
your report.
eg. YourVariable = FormatNumber(YourNum, , , , vbTrue)
Regards
Shaun
--
ShaunM
------------------------------------------------------------------------
ShaunM's Profile:
http://www.excelforum.com/member.php...o&userid=18610
View this thread:
http://www.excelforum.com/showthread...hreadid=478646