Hi Manoj, Maybe what you are try to say, you want to export your generated report arranged by barcode? Am I right? In that case you may edit your data through excel. *Steps* Step 1 Highlight the whole column of the "barcode" Step 2 click cnrt+H Step 3 Find what = A Replace with = *note leave it blank click Replace All (so that you can remove the "A" symbol) Step 4 Go to *Data* and sort your column to A - Z Step 5 Make a new column beside the barcode column then type ="A"&(the column with the number 1) then press enter and then drag the formula to put A back Regards, - Jerwyn On Sat, Mar 29, 2014 at 12:20 PM, manoj382093 <manojkumarmisra@gmail.com>wrote:
Dear Friends, I have used alphabets in barcode numerbers for different item types, now when i have generated the accession register sorted by barcode it sort like A1, A11, A12, A21.. etc instead of A1,A2,A3,A4.....
Please help!
Manoj Kumar Misra
-- View this message in context: http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.htm... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jerwyn G. Fernadez Basic Education Librarian Southville International School and Colleges