does anyone have an idea how to help with the following problem?
When exporting documents into excel sheet which contain numbers eg. 48,00 the excel import deletes the comma and 4800 is now written in the export. Thanks in advance for your help!
As Asana doesn’t allow defining a different delimiter, I would suggest to work on your Excel settings.
Indeed, Excel’s interpretation of numbers often depends on the regional settings of the computer. In some countries, the comma is used as a decimal separator, while in others, the period is used.
Explicitly Define Data Type During Import:
- If you’re importing data into Excel (e.g., from a CSV), you can specify the data type for each column.
- When the import wizard shows up:
- Select the column with the numbers.
- Choose ‘Text’ as the data type. This ensures that Excel doesn’t try to interpret the numbers and retains them as they are.
Open the file in another spreadsheet viewer/editor (such as Google Sheet); it might do the trick
Hope that is helpful, if not, please let me know
Hi @Arthur_BEGOU ,
thanks a lot. That worked!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.