I'm still a little confused what you mean by text vs integer columns, is this the setting inside calibre itself? This is how I created the actual column.
Are you suggesting I change the template to display padded with zeroes?
http://i.imgur.com/VyACh2i.png