Find a function with three decimal places for any value

lkc20061985

As the title

winoudzhang

Debug.Print Format (125.81256, "# .000")

彻底复仇

cint ((num-int (num)) * 1000) / 1000

rockyoung

? FormatNumber (123.456789,3)
? Round (123.456789,3)
? Format (123.45678, "# .000")

张家太太

The above methods can meet the requirements, the key is to choose according to the actual situation!