User Form Txt Box calculation converting kg/min to T/Hour must show T/H and have comma

Hi There..

I have the code below that is a simple calculation where a weight per minute is multiplied to give a total weight per hour. The calculation works but I need the format to show with a text addition as well as a comma or point between ton and kilogram. For example if I enter a value in Textbox_TotalSandKGM of 216 (Which refers to kg/min) then the result is "12960" but I need it to show as "12,960 Ton per Hour"

Please Login or Register  to view this content.

Anyone knows what I need to add here?

Here you go:

Textbox_SandWeightTPH = Format( Textbox_TotalSandKGM * 60 / 1000 , "0.000") & " Ton per Hour"

Blue is the original formula.

Originally Posted by dgranneman

Here you go:

Textbox_SandWeightTPH = Format( Textbox_TotalSandKGM * 60 / 1000 , "0.000") & " Ton per Hour"

Blue is the original formula.

Tks...it works! Will mark thread as solved and add reputation!