On 4/12/07, James Elliott <[EMAIL PROTECTED]> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
