[Solved] $values from CSV export

[Oohappyuser]

Hi,
I export bank transactions from the bank as .csv files and they open in Calc. I copy and paste into another Calc spreadsheet.

Recently I suspect the bank may have changed something and the debits and credits do not sum unless I type them into the cells. I notice that the amounts as pasted appear fully to the left of the cells but if I type them in they are fully to the right.

What is the best solution please?

[RusselB]

If the file(s) from the bank are true CSV files, then you can open them directly with Calc.
Doing so should bring up the Text Import dialog, where you can select comma as a separator (it may even be selected automatically)
I have one bank where all of the debits and credits show in a single column, with the debits showing as positive numbers and credits as negative numbers.
I have another bank where the debits and credits show in two different columns
In both cases I don't have the Merge delimiters option checked, as, for the 2nd bank, having that checked, makes the debits and credits go into one column, and they all show as positive numbers.

Thus my suggestion is to open the CSV file in Calc (using File -> Open), and in the Text Import dialog, have just Comma checked.
Optionally, you can have the Detect special numbers option checked, but that shouldn't affect the debits/credits importation.

[Oohappyuser]

Great thanks RusselB. Having "Detect special numbers" checked was the answer and the only thing I hadn't tried (I think). I also have the Comma checked and it all works for me now.