# Quick Export of Money datatype is stored as text in excel instead of number

**URL:** <https://forums.toadworld.com/t/quick-export-of-money-datatype-is-stored-as-text-in-excel-instead-of-number/38225>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [August 22, 2016, 2:05pm UTC](https://forums.toadworld.com/t/quick-export-of-money-datatype-is-stored-as-text-in-excel-instead-of-number/38225 "2016-08-22T14:05:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![alloyd\_640](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@alloyd\_640](https://forums.toadworld.com/u/alloyd_640)\
**Post date:** [August 22, 2016, 2:05pm UTC](https://forums.toadworld.com/t/quick-export-of-money-datatype-is-stored-as-text-in-excel-instead-of-number/38225/1 "2016-08-22T14:05:37Z")

</div>

I work in a large Microsoft SQL Server data warehouse that unfortunately uses the Money datatype in many places. For years I have been exporting data to excel and sending off to whoever. Recently though, since I upgraded to TDP 4.0.0.624, when I quick export a dataset to an excel file, the money datatype columns are stored as text. BUT, if I do a quick export to an excel instance, the money columns are stored as numbers and it works fine. So this issue only occurs when exporting straight to a file.

If it makes any difference, we are on office 2007.

---

<div class="post-metadata">

**Author:** ![Filip.Cevela](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/filip.cevela/32/200_2.png) [@Filip.Cevela](https://forums.toadworld.com/u/Filip.Cevela)\
**Post date:** [August 23, 2016, 4:47am UTC](https://forums.toadworld.com/t/quick-export-of-money-datatype-is-stored-as-text-in-excel-instead-of-number/38225/2 "2016-08-23T04:47:46Z")

</div>

Hi,

I was able reproduce your problem and we are sorry about it. I created task QAT-8499 and we will fix this issue.

Filip

---

<div class="post-metadata">

**Author:** ![alloyd\_640](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@alloyd\_640](https://forums.toadworld.com/u/alloyd_640)\
**Post date:** [August 23, 2016, 6:38am UTC](https://forums.toadworld.com/t/quick-export-of-money-datatype-is-stored-as-text-in-excel-instead-of-number/38225/3 "2016-08-23T06:38:24Z")

</div>

Great, thank you!