I'm saving several eg. 000001 inside a SQL TEXT area which in turn causes the key zeros to become lost.

I want the written text type area because the data could have letters and/or amounts.

Any suggestions the way i could preserve the key zeros while still storing the information inside a TEXT type area?

Observe that 0000001 isn't a number. It's a string. Are you currently attempting to store several one in a text area, or are you currently attempting to keep string '0000001' inside a text area? I suppose however , you do th former.

If you think maybe you aren't doing that, show us your code.