Change the way numbers behave

yogabill · 03-13-2012, 08:56 AM

After importing a series of magazines I noticed that the issue numbers organized themselves so that #1 was followed by #10. I manually changed the numbers to read 01, 02, etc but then I noticed that #101 came before #2. How do I change how numbers behave?
thanks
B

itimpi · 03-13-2012, 09:27 AM

You do not mention what field this was in? If in the title then the only way is to add any required leading zeroes as the field is simply sorted as text. There must be enough leading zeroes to cater for the highest issue number.

I use the Series fields for magazines and put issue numbers into the Series Index field (I actually tend to use year.issue eg 2011.03). Sorting on the series field will now give expected results as the series-index field is sorted numerically.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
auto change file numbers?	bobcdy	Sigil	3	03-13-2012 03:18 AM
Unwanted page numbers and font change	SoulStyle	Conversion	5	05-21-2011 04:58 PM
how to make images behave....	soup	ePub	2	08-16-2010 11:14 AM
ePub - Changing Font size doesn't change page numbers	higgs	Sony Reader	46	03-26-2010 02:36 PM
Programs that may behave differently in WinXP SP2	Colin Dunstan	Lounge	1	08-15-2004 10:56 AM

03-13-2012, 08:56 AM	#1
yogabill Junior Member Posts: 3 Karma: 10 Join Date: Feb 2012 Device: Kindle	Change the way numbers behave After importing a series of magazines I noticed that the issue numbers organized themselves so that #1 was followed by #10. I manually changed the numbers to read 01, 02, etc but then I noticed that #101 came before #2. How do I change how numbers behave? thanks B

03-13-2012, 09:27 AM	#2
itimpi Wizard Posts: 4,552 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	You do not mention what field this was in? If in the title then the only way is to add any required leading zeroes as the field is simply sorted as text. There must be enough leading zeroes to cater for the highest issue number. I use the Series fields for magazines and put issue numbers into the Series Index field (I actually tend to use year.issue eg 2011.03). Sorting on the series field will now give expected results as the series-index field is sorted numerically.

Advert