[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


On Thu, Apr 28, 2022 at 10:49 AM Indranil Das Gupta <indradg at gmail.com>

> 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