Value getting roung off while using to text .

[Former Member]

Dear Experts ,

I am applying below formula in Display String , But my value getting Round off .

for Ex : totext (41.665,'###,####,###.000') . I am getting output value as 41.670 , but i want to display 41.665 . Please suggest .

[former_member373051 · Accepted solution]

Hi Sri,

u can try below hope this help

totext (41.665,'###,####,###.000',3)

[Former Member]

Use this instead

totext(41.665,3, ",")

Ian