MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre
Reload this Page question: Column formatting

Notices

Reply
 
Thread Tools Search this Thread
Old 08-17-2017, 01:14 PM   #1
bulldogmo
Connoisseur
bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.
 
Posts: 65
Karma: 25748
Join Date: Apr 2011
Device: kindle
question: Column formatting
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.
bulldogmo is offline   Reply With Quote
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,062
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
Advert
Old 08-18-2017, 03:32 PM   #3
bulldogmo
Connoisseur
bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.bulldogmo knows what's going on.
 
Posts: 65
Karma: 25748
Join Date: Apr 2011
Device: kindle
okay.... thanks...... I just wanted on the sheet because of a slight OCD thing that I have
bulldogmo is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Price Custom Column Formatting Help PaulineDesigns Library Management 13 07-22-2022 09:23 PM
Formatting Series in a user defined column. How? AnselmD Library Management 4 11-03-2013 03:49 AM
Formatting Floating Point # Custom Column GeekyGal Library Management 3 06-03-2011 05:34 PM
Formatting Question HiddenZebra Amazon Kindle 2 06-26-2010 02:16 AM
line formatting formatting question daesdaemar Workshop 9 02-06-2009 11:47 AM


All times are GMT -4. The time now is 05:52 PM.

Contact Us - FAQ - Guidelines - Privacy - Top

MobileRead.com is a privately owned, operated and funded community.