Strange display fo calculation resulot in Base query

"Gert Blij" <[email protected]> Wed, 24 Aug 2005 11:49:33 +0200

Newsgroups	gmane.comp.openoffice.dba.user
Organization	Gert Blij
Message-ID	<[email protected]>

OOo Beta 2 122 on Windows XP

I query 2 fields and use them to calculate a third, i.e.

SELECT `field1`, `field2`, `field1` - `field2` AS `Difference` FROM `table` 

If field 1 > field2 the result displays correctly, but if field1 < field2 id
siplays in "scientific format" like 12E345.

Is there anyway to format the query so that the result displays as "-n"?

TIA
Gert