Data formatting

Results 1 to 2 of 2

Thread: Data formatting

  1. #1
    Rob Crooks Guest

    Default Data formatting

    Having problems formatting output to include trailing zeros.<BR>I have a row inside an SQL table that is has numeric as data type. It contains values like 0.018 with a precision of 6 places so that an sql query shows 0.018000, which is what I want. But the output I get is still 0.018. I am using the expression &#060;%=Server.HTMLEncode(rs.Fields("code").Value) %&#062; to put the values into a drop-down list. How can I format my output to keep the trailing zeros? Can I remove the leading zeros? <BR><BR>I appreciate any help...

  2. #2
    Join Date
    Dec 1969

    Default In the docs...

    Look at the VBScript BUILT IN function FormatNumber in your handy dandy VBScript documentation. (And you can go to to find it if you don&#039t have it on your own machine.)<BR><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