Last edit
Deleted:
< <<<<<<< you
Deleted:
< ||||||| ancestor
< DeletedPage=======
< = Converting numbers =
< When importing my bank accounts, I get one column with the amount before the comma and one column with the remainder amount:
< 10-JUL-2008 -20 10 BANK COSTS
< To create one column with just one number:
< =WAARDE(TEKST.SAMENVOEGEN(B1;",";C1/100))
< >>>>>>> other
When importing my bank accounts, I get one column with the amount before the comma and one column with the remainder amount:
10-JUL-2008 -20 10 BANK COSTS
To create one column with just one number:
=WAARDE(TEKST.SAMENVOEGEN(B1;",";C1))