Sorry to reply to my own message but I want to add the following
information: If I use no formatting the amount is correct, so it isn't a
data source problem.

Also I,m using MS query to access data off an IBM I-series