show in two decimal

[soniasweety]

Hi  all,

Jyothish KC

Frank Hartmann

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%

[andrey_krylov · Accepted solution]

Hi Sony, maybe this

Num(100.00000455, '#,##0.00') & '%'

or this

Num(100.00000455/100, '#,##0.00%')

[soniasweety]

thanks for your response.  second one looks cool

can you have look on below thread.

range

[Frank_Hartmann]

try this:

num(round(100.00000455,0.01)/100,'#.##%')

[soniasweety]

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?

range