# Some Project IDs and Task IDs not displaying properly on export

**URL:** <https://forum.asana.com/t/some-project-ids-and-task-ids-not-displaying-properly-on-export/77266>\
**Category:** Ask the Community\
**Created:** [12 March 2020 16:10 UTC](https://forum.asana.com/t/some-project-ids-and-task-ids-not-displaying-properly-on-export/77266 "2020-03-12T16:10:19Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![Phil\_Seeman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/phil_seeman/32/81525_2.png) [@Phil\_Seeman](https://forum.asana.com/u/Phil_Seeman)\
**Post date:** [27 April 2020 14:30 UTC](https://forum.asana.com/t/some-project-ids-and-task-ids-not-displaying-properly-on-export/77266/9 "2020-04-27T14:30:24Z")

</div>

> [@Phil\_Seeman](#):
>
> (Don’t bother trying Excel - I spent hours trying every formatting possibility I could think of, and never got IDs displaying properly in Excel.)

Oops, that’s wrong - I had completely forgotten that I did figure out a way to have the IDs work properly in Excel! See:

> [@Duplicating Tasks also duplicates the Task ID](https://forum.asana.com/t/duplicating-tasks-also-duplicates-the-task-id/60733/4):
>
> @Charles_Haynie, I did figure out a way to do it - not sure if this is the only way but it worked. Instead of just double-clicking the CSV to open it in Excel which causes Excel to assume the ID column is numeric, which causes it to lose the last digit because it can’t handle numeric values that large, do this: Open Excel, select New for a new blank workbook. Go to the Data tab; select Get & Transform Data \> From Text/CSV Browse to and select your exported CSV file and click Import. In the r…

---

_[View the full topic](https://forum.asana.com/t/some-project-ids-and-task-ids-not-displaying-properly-on-export/77266)._