View Single Post
  #2   Report Post  
NEMB NEMB is offline
Junior Member
 
Posts: 3
Default

Quote:
Originally Posted by gundesvan View Post
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 ### ### ###