FormatNumber
in [ASP]
|
From: MiniEggs on 4 Dec 2009 07:33 Hi Why would FormatNumber(1,2,0,0,0) return 1,00 instead of 1.00 ? All docs I've found on the web suggest it should return 1.00 Thanks in advance
From: Tim Slattery on 4 Dec 2009 08:39 "MiniEggs" <b(a)a.com> wrote: >Hi > >Why would FormatNumber(1,2,0,0,0) return 1,00 instead of 1.00 ? Check the "Regional and Language Options" control panel applet on the server, that's what controls this. Europeans use a comma to separate the fraction from the integer, the US uses a period. You probably want to set the region to "English, United States". -- Tim Slattery Slattery_T(a)bls.gov http://members.cox.net/slatteryt
From: MiniEggs on 4 Dec 2009 08:59 Hi Tim Thanks for the reply I have asked for this to be checked The odd thing is though all three of these return the same result Response.Write FormatNumber(1,2,-2,-2,-2) Response.Write FormatNumber(1,2,-1,-1,-1) Response.Write FormatNumber(1,2,0,0,0) I would have thought 0 should mean the regional settings are ignored ? Thanks "Tim Slattery" <Slattery_T(a)bls.gov> wrote in message news:u44ih55mtnojbrtuo0jeh76drkodd1b2de(a)4ax.com... > "MiniEggs" <b(a)a.com> wrote: > >>Hi >> >>Why would FormatNumber(1,2,0,0,0) return 1,00 instead of 1.00 ? > > Check the "Regional and Language Options" control panel applet on the > server, that's what controls this. Europeans use a comma to separate > the fraction from the integer, the US uses a period. You probably want > to set the region to "English, United States". > > -- > Tim Slattery > Slattery_T(a)bls.gov > http://members.cox.net/slatteryt
From: Bob Barrows on 4 Dec 2009 09:11 Tim Slattery wrote: > "MiniEggs" <b(a)a.com> wrote: > >> Hi >> >> Why would FormatNumber(1,2,0,0,0) return 1,00 instead of 1.00 ? > > Check the "Regional and Language Options" control panel applet on the > server, that's what controls this. Europeans use a comma to separate > the fraction from the integer, the US uses a period. You probably want > to set the region to "English, United States". > One gotcha here is that the user profile whose Regional Settings are manifesting in ASP might not be the user profile under which you are logging into the server to check the Regional Settings. It might be the IUSR account depending on how the website is configured. There are several KB articles that deal with this issue so let me point you at these search results: http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLD,GGLD:2003-36,GGLD:en&q=%22Regional+Settings%22+IIS+ASP+site%3asupport%2emicrosoft%2ecom+ -- HTH, Bob Barrows
From: Bob Barrows on 4 Dec 2009 09:35 No. None of these arguments affects the decimal separator used. The last argument will affect the thousands separator, but that's it. I try to avoid formatnumber, formatdate and formatcurrency, for these reasons. If I need to format a string, I do it explicitly. See http://www.aspfaq.com/show.asp?id=2313 for some suggestions. MiniEggs wrote: > Hi Tim > > Thanks for the reply > > I have asked for this to be checked > > The odd thing is though all three of these return the same result > > Response.Write FormatNumber(1,2,-2,-2,-2) > Response.Write FormatNumber(1,2,-1,-1,-1) > Response.Write FormatNumber(1,2,0,0,0) > > I would have thought 0 should mean the regional settings are ignored ? > > Thanks > > "Tim Slattery" <Slattery_T(a)bls.gov> wrote in message > news:u44ih55mtnojbrtuo0jeh76drkodd1b2de(a)4ax.com... >> "MiniEggs" <b(a)a.com> wrote: >> >>> Hi >>> >>> Why would FormatNumber(1,2,0,0,0) return 1,00 instead of 1.00 ? >> >> Check the "Regional and Language Options" control panel applet on the >> server, that's what controls this. Europeans use a comma to separate >> the fraction from the integer, the US uses a period. You probably >> want to set the region to "English, United States". >> >> -- >> Tim Slattery >> Slattery_T(a)bls.gov >> http://members.cox.net/slatteryt -- HTH, Bob Barrows
|
Pages: 1 Prev: session variables and performance Next: Get "Comments" from File property on ASP web page |