# Incorrect Reference No When Copy Sales Invoice To Clip Board

**URL:** <https://forum.manager.io/t/incorrect-reference-no-when-copy-sales-invoice-to-clip-board/46426>\
**Category:** Uncategorized\
**Created:** [April 10, 2023, 8:47am UTC](https://forum.manager.io/t/incorrect-reference-no-when-copy-sales-invoice-to-clip-board/46426 "2023-04-10T08:47:51Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elvie\_Periscilla\_Eli](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/elvie_periscilla_eli/32/21927_2.png) [@Elvie\_Periscilla\_Eli](https://forum.manager.io/u/Elvie_Periscilla_Eli)\
**Post date:** [April 10, 2023, 8:47am UTC](https://forum.manager.io/t/incorrect-reference-no-when-copy-sales-invoice-to-clip-board/46426/1 "2023-04-10T08:47:51Z")

</div>

Hi,

I have long reference number in sales Invoice.

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/6/f6f769787bf24e3bfec9a6a3d035aaccec843f4c.png)

When i copy to clip board them move to excel, it becomes like below picture.

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/a/fa568e52f0113303165a40268bf66c5dc5aa023f.png)

Once we open, the number becomes the same.

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/3/c3e545382c09b20f397a40a03b20190cd18cfd7b.png)

how to take the actual ref no?

thank you

Elvie

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [April 10, 2023, 9:02am UTC](https://forum.manager.io/t/incorrect-reference-no-when-copy-sales-invoice-to-clip-board/46426/2 "2023-04-10T09:02:40Z")

</div>

You need to format the cell differently in Excel

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [April 10, 2023, 9:02am UTC](https://forum.manager.io/t/incorrect-reference-no-when-copy-sales-invoice-to-clip-board/46426/3 "2023-04-10T09:02:44Z")

</div>

That’s and Excel issue.  
In Libreoffice the column can be selected for import as text not a number. I’m not sure how to do that in Excel

---

<div class="post-metadata">

**Author:** ![Elvie\_Periscilla\_Eli](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/elvie_periscilla_eli/32/21927_2.png) [@Elvie\_Periscilla\_Eli](https://forum.manager.io/u/Elvie_Periscilla_Eli)\
**Post date:** [April 10, 2023, 3:19pm UTC](https://forum.manager.io/t/incorrect-reference-no-when-copy-sales-invoice-to-clip-board/46426/4 "2023-04-10T15:19:31Z")

</div>

@Joe91 : may i know how to format the cell differently? i have tried even paste refreshable web query but still the number becomes 000.

Hi all,

do you have any idea to solve that? as we always work using manager io and excel.

thank you

Elvie

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [April 10, 2023, 3:30pm UTC](https://forum.manager.io/t/incorrect-reference-no-when-copy-sales-invoice-to-clip-board/46426/5 "2023-04-10T15:30:24Z")

</div>

Did you even try different formats?

Anyway -  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/a/aacf53efc60b0f0494de80934fa5178d9af7a93a.png)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/9/390f9bc919b6fc3a05f6553ddb0af3c74d4dce0a.png)

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [April 10, 2023, 4:07pm UTC](https://forum.manager.io/t/incorrect-reference-no-when-copy-sales-invoice-to-clip-board/46426/6 "2023-04-10T16:07:09Z")

</div>

I am closing this topic. This forum is not the place for instruction on spreadsheets.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [April 10, 2023, 4:07pm UTC](https://forum.manager.io/t/incorrect-reference-no-when-copy-sales-invoice-to-clip-board/46426/7 "2023-04-10T16:07:13Z")

</div>

Closed on April 10, 2023, 4:07pm UTC


