Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I display a numeric value without it being chopped?

Status
Not open for further replies.

wniatbms

Programmer
Dec 5, 2003
24
0
0
ZA
Good day

In my table I have a column containing values with 2 decimal places. These values could be:

180.00
1.63
1.00
0.84
0.10

When I retrieve them on a web page, they display as such:

180
1.63
1
0.84
0.1

I really need them to display as they are in the table. Any help would be greatly appreciated.

William
 
Hi

Look at the formatnumber function

formatnumber(yourvalue, 2, , 0)



--------------------------------
Codito, ergo sum
 
gpzcrasher...

Beautiful! It worked. THank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top