# Data.ExportExcel - Numbers recognize as Text

**URL:** <https://forum.dynamobim.com/t/data-exportexcel-numbers-recognize-as-text/33836>\
**Category:** Revit\
**Created:** [March 21, 2019, 1:23pm UTC](https://forum.dynamobim.com/t/data-exportexcel-numbers-recognize-as-text/33836 "2019-03-21T13:23:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![KlausMunkholm](https://avatars.discourse-cdn.com/v4/letter/k/a6a055/32.png) [@KlausMunkholm](https://forum.dynamobim.com/u/KlausMunkholm)\
**Post date:** [March 21, 2019, 1:23pm UTC](https://forum.dynamobim.com/t/data-exportexcel-numbers-recognize-as-text/33836/1 "2019-03-21T13:23:53Z")

</div>

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](https://forum.dynamobim.com/uploads/short-url/54qMBIllWxQ8YbrtPVRQcBZwsml.dyn) (29.6 KB)

 ![schedules_excel](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/6/a688e7100bfb3e6155d8366ba036339898a7ddc3.png) ![schedules_excel_a](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/c/9c4427ba60e59956da755c26149340ae2f485082.png) ![schedules_excel_b](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/c/9c4427ba60e59956da755c26149340ae2f485082.png)

---

<div class="post-metadata">

**Author:** ![KlausMunkholm](https://avatars.discourse-cdn.com/v4/letter/k/a6a055/32.png) [@KlausMunkholm](https://forum.dynamobim.com/u/KlausMunkholm)\
**Post date:** [March 21, 2019, 2:08pm UTC](https://forum.dynamobim.com/t/data-exportexcel-numbers-recognize-as-text/33836/2 "2019-03-21T14:08:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Laura\_BIMChick](https://avatars.discourse-cdn.com/v4/letter/l/bbce88/32.png) [@Laura\_BIMChick](https://forum.dynamobim.com/u/Laura_BIMChick)\
**Post date:** [August 28, 2019, 6:18am UTC](https://forum.dynamobim.com/t/data-exportexcel-numbers-recognize-as-text/33836/3 "2019-08-28T06:18:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![KlausMunkholm](https://avatars.discourse-cdn.com/v4/letter/k/a6a055/32.png) [@KlausMunkholm](https://forum.dynamobim.com/u/KlausMunkholm)\
**Post date:** [August 28, 2019, 8:16am UTC](https://forum.dynamobim.com/t/data-exportexcel-numbers-recognize-as-text/33836/4 "2019-08-28T08:16:56Z")

</div>

![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/7/c7b8577e35dd53ac5ff08078661c6c65d34f4a83.png)

---

<div class="post-metadata">

**Author:** ![Laura\_BIMChick](https://avatars.discourse-cdn.com/v4/letter/l/bbce88/32.png) [@Laura\_BIMChick](https://forum.dynamobim.com/u/Laura_BIMChick)\
**Post date:** [August 28, 2019, 9:49am UTC](https://forum.dynamobim.com/t/data-exportexcel-numbers-recognize-as-text/33836/5 "2019-08-28T09:49:49Z")

</div>

Thanks, it worked for me!