help... trailing zeros get deleted

# Thread: help... trailing zeros get deleted

1. KL
Senior Member
Join Date
Dec 1969
Posts
595

## help... trailing zeros get deleted

I&#039;m trying to display a decimal field. For some reason I lose all the trailing zeros for all numbers with trailing zeros. For example 100 would be displayed as "1", 250 would be "25", 1230 would be "123", etc... Does anyone know what&#039;s the problem? <BR>Thanks in advance!

2. Ck
Member
Join Date
Dec 1969
Posts
55

## RE: help... trailing zeros get deleted

Try the FormatNumber(number) function, that may help.

3. KL
Senior Member
Join Date
Dec 1969
Posts
595

## RE: help... trailing zeros get deleted

I tried FormatNumber(x,2) but it still returns the incorrect result. Ex. 120 would display 12.00, 123000 would be 123.00. It deletes the 0 preceding the decimal point. Why??

4. Ck
Member
Join Date
Dec 1969
Posts
55

## RE: help... trailing zeros get deleted

,2 is telling it to format it with 2 decimal places, do ,0.

5. KL
Senior Member
Join Date
Dec 1969
Posts
595

## RE: help... trailing zeros get deleted

Format to 0 didn&#039;t make a dirrence.. it displays as an integer. 150 displays as 15

6. Ck
Member
Join Date
Dec 1969
Posts
55

## RE: help... trailing zeros get deleted

Hmmm...got me, sorry I couldn&#039;t help.

7. Member
Join Date
Dec 1969
Posts
43

## RE: Maybe... trailing zeros get deleted

Have you checked your formulas? Almost sounds like you divided by 100 (i.e. converting to/from a percentage).

8. KL
Senior Member
Join Date
Dec 1969
Posts
595

## RE: Maybe... trailing zeros get deleted

No.... I&#039;m trieving it as any other fields. <BR><BR>Response.Write rs("myvalue")<BR>...<BR><BR>I&#039;m using Progress Database I wonder if this is the problem..<BR>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•