Skip to Content
1
Jan 11, 2022 at 07:41 AM

Number formatting in CSV file

427 Views Last edit Jan 21, 2022 at 09:47 AM 2 rev

Hi all

I have some issues with the number formatting in CSV-files. If I export a table from a story in a CSV-file some of the numbers are formated as a date. (Please see screenshot below)

format.png

If I chose the option "Include number formatting (convert numbers to strings)" I get the numbers with the scale (in my case "Hours") so I can't do further calculations in Excel with them.

Do have any tips to prevent Excel from converting the numbers in a date format?

Thanks and best regards
Stefan

Attachments

format.png (36.9 kB)