# End of Year Holdings Report

**URL:** <https://discuss.koinly.io/t/end-of-year-holdings-report/536>\
**Category:** Koinly Support\
**Created:** [November 2, 2020, 9:29am UTC](https://discuss.koinly.io/t/end-of-year-holdings-report/536 "2020-11-02T09:29:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnzh](https://avatars.discourse-cdn.com/v4/letter/j/53a042/32.png) [@johnzh](https://discuss.koinly.io/u/johnzh)\
**Post date:** [November 2, 2020, 9:29am UTC](https://discuss.koinly.io/t/end-of-year-holdings-report/536/1 "2020-11-02T09:29:24Z")

</div>

Any items with a Cost or Value greater than 999.99 include a ‘,’ - example 12,345.67

This is interpreted by Excel as text, rather than a numeric value, which requires a manual fix to convert back to a numeric value.

The Quantity value does not have this problem.

---

<div class="post-metadata">

**Author:** ![ConorIA](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/conoria/32/168_2.png) [@ConorIA](https://discuss.koinly.io/u/ConorIA)\
**Post date:** [November 3, 2020, 1:08pm UTC](https://discuss.koinly.io/t/end-of-year-holdings-report/536/2 "2020-11-03T13:08:40Z")

</div>

Not a fix, but Data \> Text to Columns should take care of that in a couple of clicks. You could record a macro if you need to do it often.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex052/uploads/koinly_app/original/1X/7ac58e5593a7122893d066794a7254dcdb5ddb31.png) [@system](https://discuss.koinly.io/u/system)\
**Post date:** [November 2, 2021, 1:42pm UTC](https://discuss.koinly.io/t/end-of-year-holdings-report/536/3 "2021-11-02T13:42:50Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.