Skip to Content
0

UDF to pad zeroes to decimal value

Jan 30 at 01:37 PM

30

avatar image

Hi Experts,

We have requirement like if input field is a decimal value like 25, 32.2, 41.32, 58.865 then output should be decimal value with 3 values after "." [dot] like input & output as below:

Input --> Output

25 ---> 25.000

32.2 --> 32.200

41.32 --> 41.320

58.865 --> 58.865

Please help to achieve this.

Thanks,

Ramu.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Raghuraman S Jan 31 at 05:14 AM
0

Try format number with .000


capture1.png (2.1 kB)
capture.png (4.3 kB)
Share
10 |10000 characters needed characters left characters exceeded