Formatting numbers

[patvdp]

When I put number fields into a published database (made with Home Page) they look like this :

123456

What do I have to do to display them formatted like 123.456 or 123,456?

Setting the number format options didn't work.

Patrick

[Vaughan]

Create a calculation field that formats the number using text functions. The disadvantage of doing this is that 1) the value is returned as text; and 2) remember people must enter the value through the original field not the caculation, which is really just for display.

[patvdp]

Thanks, that should work.

Is there a solution on the browser side, like adding some HTML code?