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 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)
http://www.ycoln-resources.com
FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"john elfrank" <(E-Mail Removed)> wrote in message
news:0af801c3a53a$85f79f70$(E-Mail Removed)...
> 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 Removed)
> http://www.elfrank.org