Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have expression vSEG which is
=1-MARKUP_SUB
now display as 0.25
may i know how to make it display as 25%
Paul
Hi Paul,
I have two method to do this job.
Method1 : vSEG =Num(1-MARKUP_SUB,'#,##0%')
Method 2: Keep your vSEG = 1-MARKUP_SUB
Right click on Input Box -> Property -> Number Tab -> Select Number and check Show in Percent (%)
Regards,
Sokkorn
Enclosed my QV Doc
Hi Paul,
I have two method to do this job.
Method1 : vSEG =Num(1-MARKUP_SUB,'#,##0%')
Method 2: Keep your vSEG = 1-MARKUP_SUB
Right click on Input Box -> Property -> Number Tab -> Select Number and check Show in Percent (%)
Regards,
Sokkorn
HI,
try with this:
NUM( YourExpression,'#,##0%')
Hi SOK and other
Thank for give me 2 approach.
1 appraoch can , 2nd cannot as my list box have many field.
Paul
Hi SOK
i though is not possible for 2nd approach , just try and found it work too.
Thank
Paul
Hi Paul,
It possible, just select each variable and set number format accordingly.
Regards,
Sokkorn