Setting Cell Formats with xlwt format strings
import time
import datetime
Time = datetime.datetime.now()
Currency = 234
#Format Date
style1 = xlwt.XFStyle()
style1.num_format_str = 'DD-MM-YY'
#Format Currency
style2 = xlwt.XFStyle()
style2.num_format_str = '$#,##0.00'
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('Sheet1')
worksheet.write(0, 1, Time, style1)
worksheet.write(0, 2, Currency, style2)
I've found a list. I was just being stupid about looking for it.
The GitHub project has a list of number format strings here:
https://github.com/python-excel/xlwt/blob/master/examples/num_formats.py