Leading zero

[huskerfan1]

When I import a field with a leading 0 it disappears. It there a way to keep the leading zero?

Example:

"05" comes across and is displayed as "5"

 

[Ngolem]

when you "import" the field?? do you mean just gather data from a database??

If the data is just being displayed then create a formula to add it back

"0" + totext({Table.numberfield},0)

if it is for numbers less than 10 then

if {Table.numfield} < 10 and {Table.numfield} > -10 then
&quot;0&quot; + totext({Table.numberfield},0)
else
totext({Table.numberfield},0);

I am assuming no decimal places here Jim Broadbent

 

[huskerfan1]

Thanks. The problem is the field it a 3 digit zip code and I need it to display 005 or 025 instead of 5 or 25. Any suugestions when you want it to be like that?

 

[Ngolem]

oh...that is no problem....You should have described it like that at first:

use:

totext({table.zipcode},&quot;000&quot

that should work Jim Broadbent