Thread: question: Column formatting
View Single Post
Old 08-17-2017, 09:03 PM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,079
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by bulldogmo View Post
Currently This is what I have in the series column:

Lt. Leary[6]

I want it to show and save:

Lt. Leary[06]

Is this possible? I can get it to save to disk in that format, but not sure how to get to show in the column inside calibre.
You do not need (and calibre can't do it) the leading 0 INSIDE the spreadsheet. Inside, the 6 is a floating point number and sorts properly .
STD or send to device, convert to Alpha-numeric. THAT needs leading 0 padding
theducks is offline   Reply With Quote