Re: need to create a numeric number

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Demetrios Panayotakopoulos (dpan__dp_at__ath.forthnet.gr)
Date: 10/28/04


Date: Thu, 28 Oct 2004 08:55:51 +0300

And in order to be more international
lnNum = VAL( STRTRAN( gnum, Set('Point'), '' ) )

Set('Point') returns the Decimal Point Character

Demetrios, Greece

"Ook" <usenet@nospam.emberts.com> wrote in message
news:%2394xAAGvEHA.3896@TK2MSFTNGP09.phx.gbl...
> lnNum = VAL( STRTRAN( gnum, ',', '' ) )
>
> lnAbsoluteValue = ABS( lnNum )
>
>
> "sherry" <sherry@discussions.microsoft.com> wrote in message
> news:C8AE544D-2230-4C38-B18F-54E9480F6CC8@microsoft.com...
>> I have a text file. I have substr a number to a variable (gnum) from this
> file.
>> I need to make the variable a numeric expression.
>> example
>> gnum='-22,455.22'
>> if I val () it returns -22.00
>> I also want the absolute of the number.
>> Please help
>> Thanks
>> Sherry
>
>



Relevant Pages