Sorry for replying only now.
Where the client enters the price:
The text box should work in millions eg: 1 000 000.00
So if they enter only 900 000.00 it should display it 900 000.00 because it works in millions.
Then in the database it should just be normal like: 1000000.00.
Then how do I display that data in the database as 1 000 000.00 on the website again?
Thank you.