How to knock off decimal places..

[Davey]

I have some code that divides a number and then prints this number. It
performs a cost rollup basically and then adds a percentage. The code works
fine except that the number returned has many figures afert the decimal
point (as you would expect really)
How can I remove these ? I am not really concerned about rounding up or
down, just removing to give me a whole number....

Many Thanks
Davey

[Evertjan.]

Davey wrote on 05 dec 2005 in microsoft.public.inetserver.asp.general:

I have some code that divides a number and then prints this number. It
performs a cost rollup basically and then adds a percentage. The code
works fine except that the number returned has many figures afert the
decimal point (as you would expect really)
How can I remove these ? I am not really concerned about rounding up
or down, just removing to give me a whole number....

If you are programming in ASP-vbscript:

formatnumber()

This is very basic, please read up on vbscript internal functions.

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)

[Davey]

No problem. I have found it !!

"Davey" <da*************@spooner-vicars.com> wrote in message
news:O9****************@TK2MSFTNGP10.phx.gbl...

I have some code that divides a number and then prints this number. It
performs a cost rollup basically and then adds a percentage. The code works fine except that the number returned has many figures afert the decimal
point (as you would expect really)
How can I remove these ? I am not really concerned about rounding up or
down, just removing to give me a whole number....

Many Thanks
Davey

[Davey]

Hi Evertjan,

I have used the FormatNumber() as you suggest. However, I am also using the
FormatCurrency() to display a cost as currency. This works fine but I get
different currency symbols on different servers !
I have checked the Regional Settings in control on both servers and they are
both set the same, but one displays $, and the other displays £....
Any ideas why this should be ??

Cheers
Davey
"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn********************@194.109.133.242...

Davey wrote on 05 dec 2005 in microsoft.public.inetserver.asp.general:

I have some code that divides a number and then prints this number. It
performs a cost rollup basically and then adds a percentage. The code
works fine except that the number returned has many figures afert the
decimal point (as you would expect really)
How can I remove these ? I am not really concerned about rounding up
or down, just removing to give me a whole number....

If you are programming in ASP-vbscript:

formatnumber()

This is very basic, please read up on vbscript internal functions.

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)

[Bob Barrows [MVP]]

It's because you are not looking at the correct Regional Settings. When you
look at Regional Settings, you are looking at your OWN settings. ASP runs
under a different user account. The default user account settings is US. You
should consider setting LCID in your application:
http://www.aspfaq.com/show.asp?id=2260

Davey wrote:

Hi Evertjan,

I have used the FormatNumber() as you suggest. However, I am also
using the FormatCurrency() to display a cost as currency. This works
fine but I get different currency symbols on different servers !
I have checked the Regional Settings in control on both servers and
they are both set the same, but one displays $, and the other
displays £....
Any ideas why this should be ??

Cheers
Davey
"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn********************@194.109.133.242...

Davey wrote on 05 dec 2005 in
microsoft.public.inetserver.asp.general:

I have some code that divides a number and then prints this number.
It performs a cost rollup basically and then adds a percentage. The
code works fine except that the number returned has many figures
afert the decimal point (as you would expect really)
How can I remove these ? I am not really concerned about rounding up
or down, just removing to give me a whole number....

If you are programming in ASP-vbscript:

formatnumber()

This is very basic, please read up on vbscript internal functions.

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Evertjan.]

Davey wrote on 06 dec 2005 in microsoft.public.inetserver.asp.general:

"Evertjan." <ex**************@interxnl.net> wrote in message

Davey wrote on 05 dec 2005 in
microsoft.public.inetserver.asp.general:

> I have some code that divides a number and then prints this number.
> It performs a cost rollup basically and then adds a percentage. The
> code works fine except that the number returned has many figures
> afert the decimal point (as you would expect really)
> How can I remove these ? I am not really concerned about rounding
> up or down, just removing to give me a whole number....
If you are programming in ASP-vbscript:

formatnumber()

This is very basic, please read up on vbscript internal functions.

[please do not toppost on usenet]
I have used the FormatNumber() as you suggest. However, I am also
using the FormatCurrency() to display a cost as currency. This works
fine but I get different currency symbols on different servers !
I have checked the Regional Settings in control on both servers and
they are both set the same, but one displays $, and the other displays
£.... Any ideas why this should be ??

Never use FormatCurrency() in an internet setting, as both the server
regional settings and the clients available fonts have influence.

<% = "€&nbsp;" & FormatNumber(yourGainOrLoss,2) %>

will do what you(?) want.

In general avoid coding that is dependent on regional settings,
though both the decimal and thousands character
are influenced by it in FormatNumber()

€ 1.234,56

or

€ 1,234.56

or ....

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)

[Davey]

Thanks Evertjan.

I see what you mean with using the FormatCurrency.

Thankyou for your help
Cheers
Davey
"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn********************@194.109.133.242...

Davey wrote on 06 dec 2005 in microsoft.public.inetserver.asp.general:

"Evertjan." <ex**************@interxnl.net> wrote in message

Davey wrote on 05 dec 2005 in
microsoft.public.inetserver.asp.general:

> I have some code that divides a number and then prints this number.
> It performs a cost rollup basically and then adds a percentage. The
> code works fine except that the number returned has many figures
> afert the decimal point (as you would expect really)
> How can I remove these ? I am not really concerned about rounding
> up or down, just removing to give me a whole number....

If you are programming in ASP-vbscript:

formatnumber()

This is very basic, please read up on vbscript internal functions.

[please do not toppost on usenet]

I have used the FormatNumber() as you suggest. However, I am also
using the FormatCurrency() to display a cost as currency. This works
fine but I get different currency symbols on different servers !
I have checked the Regional Settings in control on both servers and
they are both set the same, but one displays $, and the other displays
£.... Any ideas why this should be ??

Never use FormatCurrency() in an internet setting, as both the server
regional settings and the clients available fonts have influence.

<% = "?&nbsp;" & FormatNumber(yourGainOrLoss,2) %>

will do what you(?) want.

In general avoid coding that is dependent on regional settings,
though both the decimal and thousands character
are influenced by it in FormatNumber()

? 1.234,56

or

? 1,234.56

or ....

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)