[Koha] How to keep leading zeros when converting excel to marc

Tom Obrien tobrienu at gmail.com
Thu Apr 28 21:03:43 NZST 2022


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 at 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 at 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 at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>


More information about the Koha mailing list