Page History

When exporting an xlxs xlsx file from the Beneficiary module every column cannot be converted in the number format because the number is for example "38.0" the dot is read as a full stop and not a decimal separator as the format of the cell is "text". 

Replace function (ctrl + F) can replace all dots with a comma. This will also affect all columns if the full worksheet is selected. The format of the columns can be changed to number, or currency. If you do use currency, make sure not to include the currency symbol if intending to import the file to Beneficiary module again. 

If you wish to only select the content of the affected number columns. Use CTRL to select the first cell in the column. Keeping CTRL pressed,  press + SHIFT + ↓, this will select all cells in the column. Keeping CTRL pressed, select the first cell in next column and again use CTRL + SHIFT + ↓ to select all cells in that column. Repeat as necessary until all cells are selected. In order to keep decimal point, right click and select Format cell, change to number. Then use (ctrl + F) and replace . with ,