How to Format Number Field in ASP?

Results 1 to 2 of 2

Thread: How to Format Number Field in ASP?

  1. #1
    Join Date
    Dec 1969
    Posts
    866

    Default How to Format Number Field in ASP?

    My problem is, when I enter a value like 100.30 for a number(5,2) field, I only see 100.3 is saved in the database. The 0(zero) is missing after 3 in the decimal place. But it works fine for the values like 100.35<BR><BR>Any help please?<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    1,019

    Default RE: How to Format Number Field in ASP?

    Depends really on the database & why the appearance in the DB matters. I know in Access, a Fixed Format with 2 Decimal places will show what you want. <BR>Of course, when you return the value of the database, just use the FormatNumber function: FormatNumber(mynum,2) the 2 indicates 2 decimal places.<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
  •