YES.....you are the man..... Thanks....

-----Original Message-----
From: Neil Armstrong [mailto:neil@nancweb.com]
Sent: Monday, March 31, 2008 2:17 PM
To: 'Kim Borgman'; HP3000-L@RAVEN.UTC.EDU
Subject: RE: [HP3000-L] Query report.

Just a guess but from the back recesses of my mind and my Cobol
days:

"ZZ,ZZZ.99"

Neil

> -----Original Message-----
> From: HP-3000 Systems Discussion
> [mailto:HP3000-L@RAVEN.UTC.EDU] On Behalf Of Kim Borgman
> Sent: Monday, March 31, 2008 2:13 PM
> To: HP3000-L@RAVEN.UTC.EDU
> Subject: [HP3000-L] Query report.
>
>
> I do a lot of query reporting.
>
> Value sits as 5 cents in the data base field.
>
> Using the "E1" defination in query reporting. "ZZ,ZZZ.ZZ"
>
> It will not put the decimal in when I report it.
> D1,trans-amt,44,e1.
>
> Shows as ' 5'. Not even '05'. I want '.05'.
>
> Ideas ?
>
> I could use E1,"ZZZ,ZZZ.00" and have them divide by 100 in the
> spreadsheet.
>
> Mr. Kim Borgman
> NWS Inc.
> Indianapolis, IN
>
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>


* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *