Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have a column name is rate and now values showing as 100.00000455 [ this column is coming from directly from DB]
i want to get as a new column with 100.00%
Hi Sony, maybe this
Num(100.00000455, '#,##0.00') & '%'
or this
Num(100.00000455/100, '#,##0.00%')
Hi Sony, maybe this
Num(100.00000455, '#,##0.00') & '%'
or this
Num(100.00000455/100, '#,##0.00%')
try this:
num(round(100.00000455,0.01)/100,'#.##%')
but it is showing all 100.00% only... as i have data like 99.988 it should not round.
it should show 99.98% ..
and can u have a look into this?