Hi,
I have long reference number in sales Invoice.
When i copy to clip board them move to excel, it becomes like below picture.
Once we open, the number becomes the same.
how to take the actual ref no?
thank you
Elvie
You need to format the cell differently in Excel
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
@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
I am closing this topic. This forum is not the place for instruction on spreadsheets.
2 Likes