# format of number field

**URL:** <https://forum.servoy.com/t/format-of-number-field/16878>\
**Category:** Classic Servoy\
**Created:** [December 28, 2012, 10:57am UTC](https://forum.servoy.com/t/format-of-number-field/16878 "2012-12-28T10:57:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hans\_Nieuwenhuis](https://avatars.discourse-cdn.com/v4/letter/h/87869e/32.png) [@Hans\_Nieuwenhuis](https://forum.servoy.com/u/Hans_Nieuwenhuis)\
**Post date:** [December 28, 2012, 10:57am UTC](https://forum.servoy.com/t/format-of-number-field/16878/1 "2012-12-28T10:57:25Z")

</div>

Hi,

I have a database field of type number so it can contain any number with any decimals.

How can I make sure that what you see in the form field is exactly what is in the database ?

For instance if I use no format on the form field and I enter a value of 0,01234567 and I leave the field it shows 0,012  
but in the database the value of .0123456699999999996 is stored.  
I want to see the database value in the field.

Regards,

---

<div class="post-metadata">

**Author:** ![Andrei\_Costescu](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@Andrei\_Costescu](https://forum.servoy.com/u/Andrei_Costescu)\
**Post date:** [January 9, 2013, 3:38pm UTC](https://forum.servoy.com/t/format-of-number-field/16878/2 "2013-01-09T15:38:17Z")

</div>

A format (in locale preferences or on the field) similar to “#.####################” would do the trick.