Format Question

Hi,
I have a column with numbers like this and the output desired.
dataset output desired
0.170 0.17
0 0
1.120 1.12
0 0
But when i format it with number, #.## etc. i get "0" as 0.00 - which i
dont want
any suggestions ?
Thanks
RPRP,
If I try 0.## I get the results you are looking for. The data type for the
data is dec(5,3). With #.## I get .00 for 0 rather than 0.00. What is the
datatype of your data?
RMac
"RP" wrote:
> Hi,
> I have a column with numbers like this and the output desired.
> dataset output desired
> 0.170 0.17
> 0 0
> 1.120 1.12
> 0 0
> But when i format it with number, #.## etc. i get "0" as 0.00 - which i
> dont want
> any suggestions ?
> Thanks
> RP
>|||I take that back. I'm seeing 0.00 for zero. Let me see what I can come up
with. Apologies.
"RMac" wrote:
> RP,
> If I try 0.## I get the results you are looking for. The data type for the
> data is dec(5,3). With #.## I get .00 for 0 rather than 0.00. What is the
> datatype of your data?
> RMac
>
> "RP" wrote:
> > Hi,
> > I have a column with numbers like this and the output desired.
> >
> > dataset output desired
> > 0.170 0.17
> > 0 0
> > 1.120 1.12
> > 0 0
> >
> > But when i format it with number, #.## etc. i get "0" as 0.00 - which i
> > dont want
> > any suggestions ?
> > Thanks
> > RP
> >|||RP,
Give G5 a try. If you need a larger precision specifier, just change the 5
to the desired number.
RMac
"RP" wrote:
> Hi,
> I have a column with numbers like this and the output desired.
> dataset output desired
> 0.170 0.17
> 0 0
> 1.120 1.12
> 0 0
> But when i format it with number, #.## etc. i get "0" as 0.00 - which i
> dont want
> any suggestions ?
> Thanks
> RP
>|||G5 worked perfect. Thanks RMAC.
(Actually in the meantime i changed it to #.00, and in expression i put an
iif(no <=0 then '0') ..blah blah...
But G5 is much much easier to use. Thanks again.
"RMac" wrote:
> RP,
> Give G5 a try. If you need a larger precision specifier, just change the 5
> to the desired number.
> RMac
> "RP" wrote:
> > Hi,
> > I have a column with numbers like this and the output desired.
> >
> > dataset output desired
> > 0.170 0.17
> > 0 0
> > 1.120 1.12
> > 0 0
> >
> > But when i format it with number, #.## etc. i get "0" as 0.00 - which i
> > dont want
> > any suggestions ?
> > Thanks
> > RP
> >