Decimal space problem in FP database results display.

  • Thread starter Thread starter john elfrank
  • Start date Start date
J

john elfrank

When I insert a database and link to an Excel file in the
fpdb folder, calculated fields show several decimal
spaces. Even though I have the decminal spaces under
control in Excel, they come out on the front page results
page.

Is there any way of controling this so there are no
decimal spaces in the calculated fields of my linked
Excel file?

Thanks in advance,

John

John Elfrank-Dana
Social Studies Teacher/Web Master
Murry Bergtraum High School
(e-mail address removed)
http://www.elfrank.org
 
On your page where you display the field content you have to format the
number as you want it.

<%=FormatNumber(recordset("fieldname"),0)%>

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Back
Top