Thanks Gupta, However when I try to change the text, the leading zeros disappear. The same case when I create a cell with a single quote and combine it with a column for barcode number. Kindly help <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Thu, Apr 28, 2022 at 10:49 AM Indranil Das Gupta <indradg@gmail.com> wrote:

Hi

Format the numbers as text OR precede the number with a single quote mark

hope this helps Indranil

On Thu, 28 Apr, 2022, 12:55 pm Tom Obrien, <tobrienu@gmail.com> wrote:

...

Dear all, I am migrating records which are in excel to koha using marcedit. However when I upload to koha, the leading zeros are missing. Kindly help me so that i can keep the leading zeros. I am using koha 21 version. Regards Tom _______________________________________________

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha