Erasmus+ & European Solidarity Corps guides


Welcome

 

Change decimal separators in import export file


When exporting an 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 , 


Footnote

When possible, this glossary quotes from the programme guides. The programme guide definitions and explanations precede the definitions based in Erasmus+ and European Solidarity Corps guides. The programme guides' glossary can be downloaded or viewed on line from:

Glossary entries in this wiki assist the end user to navigate to content on how to perform related tasks in Erasmus+ and European Solidarity Corp Platform and related modules. 

Expand all   Collapse all