Decimal space problem in FP database results display.

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
 
T

Thomas A. Rowe

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.
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal space problem with FP insert database 2
Default Cell Format Hijacked to Scientific? 3
DATABASE RESULTS 1
Hyperlink Format Displayed in Database Results / FP2003 asp.webpag 1
Hyperlinks in Access Database Results Displayed in my *.asp webpag 1
Limiting Decimal Places in Database Results Page 2
Passing the results of a query(variable) to a third asp page and using it in another query 3
Localisation decimal problems 2

Top