I would like to have a number (i.e. $1,243 ) taken from my Excel
spreadsheet's total column appear on the homepage of my Frontpage 2003
website. I am able have the number appear (i.e. 1243) using ASP but it does
not have any formatting with commas or a dollar sign. I have tried to change
the formatting in Excel under the Style option and under formatting the cell.
It does not seem like it should be this difficult, am I missing something
simple ?

On the page where you are displaying the number change the ASP tag to be similar to:

<%=FormatCurrency(fp_rs("fieldname"))%>

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================


"KarenM" <(E-Mail Removed)> wrote in message
news:05B67AA8-7A1B-4112-B86C-(E-Mail Removed)...
>I would like to have a number (i.e. $1,243 ) taken from my Excel
> spreadsheet's total column appear on the homepage of my Frontpage 2003
> website. I am able have the number appear (i.e. 1243) using ASP but it does
> not have any formatting with commas or a dollar sign. I have tried to change
> the formatting in Excel under the Style option and under formatting the cell.
> It does not seem like it should be this difficult, am I missing something
> simple ?

I haven't used Excel as a data source for the DBRW, but I've done the
formatting this way with Access:
http://www.spiderwebwoman.com/resour...s.asp#currency

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others



"KarenM" <(E-Mail Removed)> wrote in message
news:05B67AA8-7A1B-4112-B86C-(E-Mail Removed)...
>I would like to have a number (i.e. $1,243 ) taken from my Excel
> spreadsheet's total column appear on the homepage of my Frontpage 2003
> website. I am able have the number appear (i.e. 1243) using ASP but it
> does
> not have any formatting with commas or a dollar sign. I have tried to
> change
> the formatting in Excel under the Style option and under formatting the
> cell.
> It does not seem like it should be this difficult, am I missing something
> simple ?

Thank you for your reply. I am new to working with ASP and its code. Do you
know
where in the code the change/addition should be made.

Is this the tag that you were referring to change?
<%=FP_FieldVal(fp_rs,"sum")%>

I tried to change this tag and when I saved the page it overwrote my changes
and would not save them. Please let me know if I was in the right area.

Thank you !

"Thomas A. Rowe" wrote:

> On the page where you are displaying the number change the ASP tag to be similar to:
>
> <%=FormatCurrency(fp_rs("fieldname"))%>
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
> http://www.Ecom-Data.com
> ==============================================
>
>
> "KarenM" <(E-Mail Removed)> wrote in message
> news:05B67AA8-7A1B-4112-B86C-(E-Mail Removed)...
> >I would like to have a number (i.e. $1,243 ) taken from my Excel
> > spreadsheet's total column appear on the homepage of my Frontpage 2003
> > website. I am able have the number appear (i.e. 1243) using ASP but it does
> > not have any formatting with commas or a dollar sign. I have tried to change
> > the formatting in Excel under the Style option and under formatting the cell.
> > It does not seem like it should be this difficult, am I missing something
> > simple ?
>
>
>

Ok, based on your example, the code would be enter like:

<%=FormatCurrency(FP_FieldVal(fp_rs,"sum"))%>

If you were hand coding.

However it appears that you are using FP DRW to generate your output, which I am not sure how your
would modify the code. Maybe Kathleen can assist you with this or better yet, follow her example.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================


"KarenM" <(E-Mail Removed)> wrote in message
news:47A9C04A-9621-426C-810B-(E-Mail Removed)...
> Thank you for your reply. I am new to working with ASP and its code. Do you
> know
> where in the code the change/addition should be made.
>
> Is this the tag that you were referring to change?
> <%=FP_FieldVal(fp_rs,"sum")%>
>
> I tried to change this tag and when I saved the page it overwrote my changes
> and would not save them. Please let me know if I was in the right area.
>
> Thank you !
>
> "Thomas A. Rowe" wrote:
>
>> On the page where you are displaying the number change the ASP tag to be similar to:
>>
>> <%=FormatCurrency(fp_rs("fieldname"))%>
>>
>> --
>> ==============================================
>> Thomas A. Rowe
>> Microsoft MVP - FrontPage
>> http://www.Ecom-Data.com
>> ==============================================
>>
>>
>> "KarenM" <(E-Mail Removed)> wrote in message
>> news:05B67AA8-7A1B-4112-B86C-(E-Mail Removed)...
>> >I would like to have a number (i.e. $1,243 ) taken from my Excel
>> > spreadsheet's total column appear on the homepage of my Frontpage 2003
>> > website. I am able have the number appear (i.e. 1243) using ASP but it does
>> > not have any formatting with commas or a dollar sign. I have tried to change
>> > the formatting in Excel under the Style option and under formatting the cell.
>> > It does not seem like it should be this difficult, am I missing something
>> > simple ?
>>
>>
>>

If you are changing code created by the DRW, you should make your changes to
the gray colored code and save the changes while still in Code view. You
will notice that once you've saved your changes they are also made to the
maroon colored code - that is by design. The maroon colored code should
never be touched; it's generated by the gray code at save time.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others



"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Ok, based on your example, the code would be enter like:
>
> <%=FormatCurrency(FP_FieldVal(fp_rs,"sum"))%>
>
> If you were hand coding.
>
> However it appears that you are using FP DRW to generate your output,
> which I am not sure how your would modify the code. Maybe Kathleen can
> assist you with this or better yet, follow her example.
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
> http://www.Ecom-Data.com
> ==============================================
>
>
> "KarenM" <(E-Mail Removed)> wrote in message
> news:47A9C04A-9621-426C-810B-(E-Mail Removed)...
>> Thank you for your reply. I am new to working with ASP and its code. Do
>> you
>> know
>> where in the code the change/addition should be made.
>>
>> Is this the tag that you were referring to change?
>> <%=FP_FieldVal(fp_rs,"sum")%>
>>
>> I tried to change this tag and when I saved the page it overwrote my
>> changes
>> and would not save them. Please let me know if I was in the right area.
>>
>> Thank you !
>>
>> "Thomas A. Rowe" wrote:
>>
>>> On the page where you are displaying the number change the ASP tag to be
>>> similar to:
>>>
>>> <%=FormatCurrency(fp_rs("fieldname"))%>
>>>
>>> --
>>> ==============================================
>>> Thomas A. Rowe
>>> Microsoft MVP - FrontPage
>>> http://www.Ecom-Data.com
>>> ==============================================
>>>
>>>
>>> "KarenM" <(E-Mail Removed)> wrote in message
>>> news:05B67AA8-7A1B-4112-B86C-(E-Mail Removed)...
>>> >I would like to have a number (i.e. $1,243 ) taken from my Excel
>>> > spreadsheet's total column appear on the homepage of my Frontpage 2003
>>> > website. I am able have the number appear (i.e. 1243) using ASP but
>>> > it does
>>> > not have any formatting with commas or a dollar sign. I have tried to
>>> > change
>>> > the formatting in Excel under the Style option and under formatting
>>> > the cell.
>>> > It does not seem like it should be this difficult, am I missing
>>> > something
>>> > simple ?
>>>
>>>
>>>
>
>

Thank you for your help. I will try to make the changes in Excel. How do
you access the SQL in Excel to make the suggested changes?

"Kathleen Anderson" wrote:

> If you are changing code created by the DRW, you should make your changes to
> the gray colored code and save the changes while still in Code view. You
> will notice that once you've saved your changes they are also made to the
> maroon colored code - that is by design. The maroon colored code should
> never be touched; it's generated by the gray code at save time.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> FrontPage Resources: http://www.spiderwebwoman.com/resources/
> Please reply to the newsgroup for the benefit of others
>
>
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Ok, based on your example, the code would be enter like:
> >
> > <%=FormatCurrency(FP_FieldVal(fp_rs,"sum"))%>
> >
> > If you were hand coding.
> >
> > However it appears that you are using FP DRW to generate your output,
> > which I am not sure how your would modify the code. Maybe Kathleen can
> > assist you with this or better yet, follow her example.
> >
> > --
> > ==============================================
> > Thomas A. Rowe
> > Microsoft MVP - FrontPage
> > http://www.Ecom-Data.com
> > ==============================================
> >
> >
> > "KarenM" <(E-Mail Removed)> wrote in message
> > news:47A9C04A-9621-426C-810B-(E-Mail Removed)...
> >> Thank you for your reply. I am new to working with ASP and its code. Do
> >> you
> >> know
> >> where in the code the change/addition should be made.
> >>
> >> Is this the tag that you were referring to change?
> >> <%=FP_FieldVal(fp_rs,"sum")%>
> >>
> >> I tried to change this tag and when I saved the page it overwrote my
> >> changes
> >> and would not save them. Please let me know if I was in the right area.
> >>
> >> Thank you !
> >>
> >> "Thomas A. Rowe" wrote:
> >>
> >>> On the page where you are displaying the number change the ASP tag to be
> >>> similar to:
> >>>
> >>> <%=FormatCurrency(fp_rs("fieldname"))%>
> >>>
> >>> --
> >>> ==============================================
> >>> Thomas A. Rowe
> >>> Microsoft MVP - FrontPage
> >>> http://www.Ecom-Data.com
> >>> ==============================================
> >>>
> >>>
> >>> "KarenM" <(E-Mail Removed)> wrote in message
> >>> news:05B67AA8-7A1B-4112-B86C-(E-Mail Removed)...
> >>> >I would like to have a number (i.e. $1,243 ) taken from my Excel
> >>> > spreadsheet's total column appear on the homepage of my Frontpage 2003
> >>> > website. I am able have the number appear (i.e. 1243) using ASP but
> >>> > it does
> >>> > not have any formatting with commas or a dollar sign. I have tried to
> >>> > change
> >>> > the formatting in Excel under the Style option and under formatting
> >>> > the cell.
> >>> > It does not seem like it should be this difficult, am I missing
> >>> > something
> >>> > simple ?
> >>>
> >>>
> >>>
> >
> >
>
>
>

The SQL is in the web page, as Thomas and Kathleen described. Excel
acts as the database, and there is no SQL there to change.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp




"KarenM" <(E-Mail Removed)> wrote in message
news:07B563E2-B4CC-475F-8409-(E-Mail Removed):

> Thank you for your help. I will try to make the changes in Excel. How do
> you access the SQL in Excel to make the suggested changes?
>
> "Kathleen Anderson" wrote:
>
> > If you are changing code created by the DRW, you should make your changes to
> > the gray colored code and save the changes while still in Code view. You
> > will notice that once you've saved your changes they are also made to the
> > maroon colored code - that is by design. The maroon colored code should
> > never be touched; it's generated by the gray code at save time.
> >
> > --
> >
> > ~ Kathleen Anderson
> > Microsoft MVP - FrontPage
> > Spider Web Woman Designs
> > Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> > FrontPage Resources: http://www.spiderwebwoman.com/resources/
> > Please reply to the newsgroup for the benefit of others
> >
> >
> >
> > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Ok, based on your example, the code would be enter like:
> > >
> > > <%=FormatCurrency(FP_FieldVal(fp_rs,"sum"))%>
> > >
> > > If you were hand coding.
> > >
> > > However it appears that you are using FP DRW to generate your output,
> > > which I am not sure how your would modify the code. Maybe Kathleen can
> > > assist you with this or better yet, follow her example.
> > >
> > > --
> > > ==============================================
> > > Thomas A. Rowe
> > > Microsoft MVP - FrontPage
> > > http://www.Ecom-Data.com
> > > ==============================================
> > >
> > >
> > > "KarenM" <(E-Mail Removed)> wrote in message
> > > news:47A9C04A-9621-426C-810B-(E-Mail Removed)...
> > >> Thank you for your reply. I am new to working with ASP and its code. Do
> > >> you
> > >> know
> > >> where in the code the change/addition should be made.
> > >>
> > >> Is this the tag that you were referring to change?
> > >> <%=FP_FieldVal(fp_rs,"sum")%>
> > >>
> > >> I tried to change this tag and when I saved the page it overwrote my
> > >> changes
> > >> and would not save them. Please let me know if I was in the right area.
> > >>
> > >> Thank you !
> > >>
> > >> "Thomas A. Rowe" wrote:
> > >>
> > >>> On the page where you are displaying the number change the ASP tag to be
> > >>> similar to:
> > >>>
> > >>> <%=FormatCurrency(fp_rs("fieldname"))%>
> > >>>
> > >>> --
> > >>> ==============================================
> > >>> Thomas A. Rowe
> > >>> Microsoft MVP - FrontPage
> > >>> http://www.Ecom-Data.com
> > >>> ==============================================
> > >>>
> > >>>
> > >>> "KarenM" <(E-Mail Removed)> wrote in message
> > >>> news:05B67AA8-7A1B-4112-B86C-(E-Mail Removed)...
> > >>> >I would like to have a number (i.e. $1,243 ) taken from my Excel
> > >>> > spreadsheet's total column appear on the homepage of my Frontpage 2003
> > >>> > website. I am able have the number appear (i.e. 1243) using ASP but
> > >>> > it does
> > >>> > not have any formatting with commas or a dollar sign. I have tried to
> > >>> > change
> > >>> > the formatting in Excel under the Style option and under formatting
> > >>> > the cell.
> > >>> > It does not seem like it should be this difficult, am I missing
> > >>> > something
> > >>> > simple ?
> > >>>
> > >>>
> > >>>
> > >
> > >
> >
> >
> >

Hi Karen:
The link I gave is to instructions on how to modify the code generated by
the FrontPage Database Results Wizard.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others



"KarenM" <(E-Mail Removed)> wrote in message
news:07B563E2-B4CC-475F-8409-(E-Mail Removed)...
> Thank you for your help. I will try to make the changes in Excel. How do
> you access the SQL in Excel to make the suggested changes?
>
> "Kathleen Anderson" wrote:
>
>> If you are changing code created by the DRW, you should make your changes
>> to
>> the gray colored code and save the changes while still in Code view. You
>> will notice that once you've saved your changes they are also made to the
>> maroon colored code - that is by design. The maroon colored code should
>> never be touched; it's generated by the gray code at save time.
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
>> FrontPage Resources: http://www.spiderwebwoman.com/resources/
>> Please reply to the newsgroup for the benefit of others
>>
>>
>>
>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Ok, based on your example, the code would be enter like:
>> >
>> > <%=FormatCurrency(FP_FieldVal(fp_rs,"sum"))%>
>> >
>> > If you were hand coding.
>> >
>> > However it appears that you are using FP DRW to generate your output,
>> > which I am not sure how your would modify the code. Maybe Kathleen can
>> > assist you with this or better yet, follow her example.
>> >
>> > --
>> > ==============================================
>> > Thomas A. Rowe
>> > Microsoft MVP - FrontPage
>> > http://www.Ecom-Data.com
>> > ==============================================
>> >
>> >
>> > "KarenM" <(E-Mail Removed)> wrote in message
>> > news:47A9C04A-9621-426C-810B-(E-Mail Removed)...
>> >> Thank you for your reply. I am new to working with ASP and its code.
>> >> Do
>> >> you
>> >> know
>> >> where in the code the change/addition should be made.
>> >>
>> >> Is this the tag that you were referring to change?
>> >> <%=FP_FieldVal(fp_rs,"sum")%>
>> >>
>> >> I tried to change this tag and when I saved the page it overwrote my
>> >> changes
>> >> and would not save them. Please let me know if I was in the right
>> >> area.
>> >>
>> >> Thank you !
>> >>
>> >> "Thomas A. Rowe" wrote:
>> >>
>> >>> On the page where you are displaying the number change the ASP tag to
>> >>> be
>> >>> similar to:
>> >>>
>> >>> <%=FormatCurrency(fp_rs("fieldname"))%>
>> >>>
>> >>> --
>> >>> ==============================================
>> >>> Thomas A. Rowe
>> >>> Microsoft MVP - FrontPage
>> >>> http://www.Ecom-Data.com
>> >>> ==============================================
>> >>>
>> >>>
>> >>> "KarenM" <(E-Mail Removed)> wrote in message
>> >>> news:05B67AA8-7A1B-4112-B86C-(E-Mail Removed)...
>> >>> >I would like to have a number (i.e. $1,243 ) taken from my Excel
>> >>> > spreadsheet's total column appear on the homepage of my Frontpage
>> >>> > 2003
>> >>> > website. I am able have the number appear (i.e. 1243) using ASP
>> >>> > but
>> >>> > it does
>> >>> > not have any formatting with commas or a dollar sign. I have tried
>> >>> > to
>> >>> > change
>> >>> > the formatting in Excel under the Style option and under formatting
>> >>> > the cell.
>> >>> > It does not seem like it should be this difficult, am I missing
>> >>> > something
>> >>> > simple ?
>> >>>
>> >>>
>> >>>
>> >
>> >
>>
>>
>>

Thank you for your help, I was able to get the number to appear in currency
with the help of your suggestions. I was able to make the change in the Drop
Down Box Properties and as a result, it changed the code that appeared in
red. The dollar sign for the currency appears, but the commas look like
periods i.e. $1.234.00 Do you have any thoughts, also I would not even mind
getting rid of the zeros and just have a dollar amount ie. $1,234

Thank you, it is great to be able to find some info on this topic.
Karen


"Kathleen Anderson" wrote:

> Hi Karen:
> The link I gave is to instructions on how to modify the code generated by
> the FrontPage Database Results Wizard.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> FrontPage Resources: http://www.spiderwebwoman.com/resources/
> Please reply to the newsgroup for the benefit of others
>
>
>
> "KarenM" <(E-Mail Removed)> wrote in message
> news:07B563E2-B4CC-475F-8409-(E-Mail Removed)...
> > Thank you for your help. I will try to make the changes in Excel. How do
> > you access the SQL in Excel to make the suggested changes?
> >
> > "Kathleen Anderson" wrote:
> >
> >> If you are changing code created by the DRW, you should make your changes
> >> to
> >> the gray colored code and save the changes while still in Code view. You
> >> will notice that once you've saved your changes they are also made to the
> >> maroon colored code - that is by design. The maroon colored code should
> >> never be touched; it's generated by the gray code at save time.
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> >> FrontPage Resources: http://www.spiderwebwoman.com/resources/
> >> Please reply to the newsgroup for the benefit of others
> >>
> >>
> >>
> >> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > Ok, based on your example, the code would be enter like:
> >> >
> >> > <%=FormatCurrency(FP_FieldVal(fp_rs,"sum"))%>
> >> >
> >> > If you were hand coding.
> >> >
> >> > However it appears that you are using FP DRW to generate your output,
> >> > which I am not sure how your would modify the code. Maybe Kathleen can
> >> > assist you with this or better yet, follow her example.
> >> >
> >> > --
> >> > ==============================================
> >> > Thomas A. Rowe
> >> > Microsoft MVP - FrontPage
> >> > http://www.Ecom-Data.com
> >> > ==============================================
> >> >
> >> >
> >> > "KarenM" <(E-Mail Removed)> wrote in message
> >> > news:47A9C04A-9621-426C-810B-(E-Mail Removed)...
> >> >> Thank you for your reply. I am new to working with ASP and its code.
> >> >> Do
> >> >> you
> >> >> know
> >> >> where in the code the change/addition should be made.
> >> >>
> >> >> Is this the tag that you were referring to change?
> >> >> <%=FP_FieldVal(fp_rs,"sum")%>
> >> >>
> >> >> I tried to change this tag and when I saved the page it overwrote my
> >> >> changes
> >> >> and would not save them. Please let me know if I was in the right
> >> >> area.
> >> >>
> >> >> Thank you !
> >> >>
> >> >> "Thomas A. Rowe" wrote:
> >> >>
> >> >>> On the page where you are displaying the number change the ASP tag to
> >> >>> be
> >> >>> similar to:
> >> >>>
> >> >>> <%=FormatCurrency(fp_rs("fieldname"))%>
> >> >>>
> >> >>> --
> >> >>> ==============================================
> >> >>> Thomas A. Rowe
> >> >>> Microsoft MVP - FrontPage
> >> >>> http://www.Ecom-Data.com
> >> >>> ==============================================
> >> >>>
> >> >>>
> >> >>> "KarenM" <(E-Mail Removed)> wrote in message
> >> >>> news:05B67AA8-7A1B-4112-B86C-(E-Mail Removed)...
> >> >>> >I would like to have a number (i.e. $1,243 ) taken from my Excel
> >> >>> > spreadsheet's total column appear on the homepage of my Frontpage
> >> >>> > 2003
> >> >>> > website. I am able have the number appear (i.e. 1243) using ASP
> >> >>> > but
> >> >>> > it does
> >> >>> > not have any formatting with commas or a dollar sign. I have tried
> >> >>> > to
> >> >>> > change
> >> >>> > the formatting in Excel under the Style option and under formatting
> >> >>> > the cell.
> >> >>> > It does not seem like it should be this difficult, am I missing
> >> >>> > something
> >> >>> > simple ?
> >> >>>
> >> >>>
> >> >>>
> >> >
> >> >
> >>
> >>
> >>
>
>
>