On Wednesday April 11 2007 9:50 pm, James Elliott wrote:
> I am a long time member of this list but have recently had a
> satellite dish installed and this address might not be registered -
> Moderator, please don't bounce this request for information as time
> is of the essence :o)
>
> I have dowloaded my transaction history from my bank as a CSV data
> with a view to adding it to my own Calc spreadheet
>
> In my spreadsheet, I have one column for CREDITS
> and another column for the DEBITS
>
> However the data from the bank is just one long list of amounts
> with credits being positive and debits being negative.
>
> No problems so far ... I created two new columns, one labelled
> CREDITS and the other labelled DEBITS and used Calc Formulas to
> sort the bank data and copy it into these columns.
>
> So now I have three columns, like this:
> BANK DATA DEBITS CREDITS
> -28.56 $28.56
> 100 $100.00
> -55.23 $55.23
>
> Before copying this into my own spreadsheet, I deleted the BANK
> DATA column because there is not place for it in my spreadsheet ...
> and you know that happened! - all data in the DEBITS & CREDITS
> columns became #Ref becuase the data was not data al all but the
> result of a formula.
>
> MY QUESTION
> Can you convert the out put of a formula to an absolute value,
> which can be copied and pasted?
>
> Many thanks, James
Two replies that you may not have seen. (I am CC'ing you in case
you would not see them other wise.)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Quick and dirty:
copy the columns with the formula results and do a paste special into
two new columns specifying that you only want to paste numbers *not*
formulas.
I am not aware of an elegant solution (but after all I am not an
elegant person :-) )
CHeers,
Michele
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
before you deleting coloumn "BANK DATA" copy coloumn "DEBITS" and
"CREDITS" then do paste special.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
