Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
I think you misunderstod me, i want the numbers to be separated when they are typed in. See attached image.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Main Form - copy exact data from multiple worksheets with live lin | Excel Worksheet Functions | |||
Form Calculations | Excel Discussion (Misc queries) | |||
separator of thousands | Excel Discussion (Misc queries) | |||
thousands comma separator in VBA | Excel Discussion (Misc queries) | |||
separator of thousands | Excel Discussion (Misc queries) |