Thousands separator in form and live calculations in form.
 

Hi

I'm making an budget template, and i wonder how i could make the numbers automatically arrange them self in thousands.

ex. when i enter 4568000 i wish that it transform into 4 568 000 while i enter it.

Is this possible?

And another question, is it possible to sum up numbers entered in forms and show them before they have been posted?

Ex. if i input estimated costs for 4 months i wish to have a line at the bottom of the VB form that automatic sum up this numbers live. Any suggestion?

format cell number custom ### ### ###

I think you misunderstod me, i want the numbers to be separated when they are typed in. See attached image.