Convert one column to numbers
<p>I have a program I am building which asks for a csv file and saves it in excel. I have one column that is currency - $10.00 - I can convert other cells to number with my code but I assume since there is a '$' before the numbers it does not convert. How can I fix this for just this one column - Thanks</p>

<pre><code>def open_csv():
from tkinter import Tk
from tkinter.filedialog import askopenfilename
import csv
from openpyxl import Workbook
from openpyxl.cell import get_column_letter

Tk().withdraw()
filename = askopenfilename()

open_rawdata = open(filename, 'r')

csv.register_dialect('commas', delimiter=',')

reader = csv.reader(open_rawdata, dialect='commas')

wb = Workbook()
dest_xls = r'C:\Users\sparkis\Desktop\WeeklyReport.xlsx'

ws = wb.worksheets[0]
ws.title = "TEST TITLE"

for row_index, row in enumerate(reader):
    for column_index, cell in enumerate(row):
        column_letter = get_column_letter((column_index + 1))
        s = cell
        try:
            s = float(s)
        except ValueError:
            pass

        ws.cell('%s%s'%(column_letter, (row_index + 1))).value = s



wb.save(filename = dest_xls)
</code></pre>