Data.ExportExcel - Numbers recognize as Text

Revit
1

I´ve created the attached DYN, and it’s working just fine, except that Excel recognize all my numbers as text. I know that I can change the formatting in Excel, but would rather not have to deal with this everytime something is updated.

Can someone tell me how to export the numbers so that Excel will recognize them as Numbers?

The DYN file creates a new Sheet in Excel for each Schedule in Revit, and populates the cells/data from each schedule to to Excel Sheet.

Thanks

schedules_excel.dyn (29.6 KB)

schedules_excel
schedules_excel.png3118×754 98 KB
schedules_excel_a
schedules_excel_a.png3118×754 139 KB
schedules_excel_b
schedules_excel_a.png3118×754 139 KB

2

Solved! Turned out to the a local thing, as we do numbers as 9.999,99 and not 9,999.99 as in Default Revit and in the US.

So simply replacing “,” with “.” in the list fixed the issue

1 Like
3

In which ‘list’ did you change this? I have the same problem but I would still like to see 9.999,99 in excel…

4

Capture
Capture.png3298×1234 193 KB

5

Thanks, it worked for me!