title: Need to remove the comma in a number in my dynamic generated classic asp site
body: <p>I have an old website which uses classic asp.  I have a problem in that whenever I display a price, if it is above £1000.00 it displays with a comma, ie £1,000.00.</p>
  
  <p>How do I force it to remove or not use the comma?</p>
  
  <p>My connection script is: </p>
  
  <pre><code>&lt;% 
                          Set adoCon = Server.CreateObject("ADODB.connection")' initialize connection
                          Set rs = Server.CreateObject("ADODB.RecordSet")' initialize record set
                          adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &amp; Server.MapPath("stockdetails.mdb")
  
                          strSQL = "SELECT * FROM StockDetails WHERE ID=" &amp;trim(pro_type)&amp;""
                          rs.open strSQL,adoCon,1,1  'open record set
                          if not rs.eof then
  
                          manufacturerid=rs("ManufacturerID")
                          manufacturer=rs("Manufacturer")
                          price=FormatNumber(rs("Price") ,2)
  
  
                          else
                          response.End()end if
  
                          rs.close
                          adoCon.close
                      %&gt;
  </code></pre>
  
  <p>The code used to pull the price onto the page is:</p>
  
  <pre><code>&lt;% = price %&gt;
  </code></pre>
  
  <p>Even if I change all the price fields in the database to display without the comma, they still show on the site with one.</p>
  
  <p>How do I get rid of it?</p>
  
  <p>Many thanks in advance.</p>
  
  <p>Ian</p>