|
| Changing sign of number |
 |
Tue, 6 Mar 2007 22:14:04 -0500 |
When importing from Quicken some numbers have a negative value. Is there a
way to change a column to positive numbers?
|
| Post Reply
|
| Re: Changing sign of number |
 |
Wed, 07 Mar 2007 08:15:03 -080 |
On Tue, 6 Mar 2007 22:14:04 -0500, "Don Eisenbarth"
<donalde@tcnet.net> wrote:
>
>When importing from Quicken some numbers have a negative value. Is there a
>way to change a column to positive numbers?
>
>
Multiply the cell times -1.
Be carefully of numeric artifacts such as -0 and .0000000000009
that can happen. -0 and 0 are NOT the /same/ to some programs.
|
| Post Reply
|
| Re: Changing sign of number |
 |
Wed, 07 Mar 2007 11:08:07 -070 |
Steve Urbach wrote:
> On Tue, 6 Mar 2007 22:14:04 -0500, "Don Eisenbarth"
> <donalde@tcnet.net> wrote:
>
>> When importing from Quicken some numbers have a negative value. Is
there a
>> way to change a column to positive numbers?
>>
>>
> Multiply the cell times -1.
> Be carefully of numeric artifacts such as -0 and .0000000000009
> that can happen. -0 and 0 are NOT the /same/ to some programs.
The downside of this method is that it also flips positive values to
negative ones. (The implication of Don's statement is that his imported
data contains BOTH positive and negative values.) Therefore, the @ABS
function is more reliable.
Cheers,
Uli
|
| Post Reply
|
| Re: Changing sign of number |
 |
Wed, 07 Mar 2007 18:07:06 GMT |
Don:
> Is there a
> way to change a column to positive numbers?
>
. . . or use @ABS()
But first be sure that the numbers are not negative for a good
reason.-)}
--
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)
|
| Post Reply
|
|
|
|
|
|
|
|
|
|