How do I export the assets correctly?

[Antonia]

I have the attribute “Device age” and there is a number in it. For example 4.56. Then I exported the file with delimiter “;”, encoding Windows 1252 and format “User friendly”. What is going wrong? Excel thinks this is a date.

[Jeroen Poismans]

Hi,

Exactly! Excel thinks it's a date. It is Excel that does this to your data therefor I never use it.

To confirm this, open your exported csv with a text-editor (notepad, notepad++ ...) and you will see that your data is untouched normally.

Excel has a setting somewhere for formatting data when opening.

Jeroen