Excel Help: Need X in one column to be changed to # in column E

[steves424]

[TABLE="width: 477"]
<COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1243" width=34><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1609" width=44><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1353" width=37><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><TBODY>[TR]
[TD="class: xl73, width: 70, bgcolor: transparent"]Supervisor[/TD]
[TD="class: xl74, width: 63, bgcolor: transparent"]Day of the Week[/TD]
[TD="class: xl73, width: 34, bgcolor: transparent"]Shift[/TD]
[TD="class: xl68, width: 44, bgcolor: #c5d9f1"]Priority (Enter 1, 2, 3 or 4)[/TD]
[TD="class: xl69, width: 49, bgcolor: white"]Total minutes spent[/TD]
[TD="class: xl70, width: 37, bgcolor: black"]Floor Time[/TD]
[TD="class: xl67, width: 51, bgcolor: #d8d8d8"]Rounds (No EE Interaction)[/TD]
[TD="class: xl71, width: 45, bgcolor: transparent"]Project [/TD]
[TD="class: xl67, width: 49, bgcolor: #d8d8d8"]Parts Search/ordering[/TD]
[TD="class: xl71, width: 49, bgcolor: transparent"]QN Investigations[/TD]
[TD="class: xl67, width: 45, bgcolor: #d8d8d8"]Assignment Board[/TD]
[TD="class: xl71, width: 47, bgcolor: transparent"]Tier Board Updates[/TD]
[TD="class: xl72, width: 51, bgcolor: #d8d8d8"]Reactive Requests[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Dooley[/TD]
[TD="class: xl66, bgcolor: transparent"]Wed[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl80, bgcolor: #c5d9f1"]4[/TD]
[TD="class: xl75, bgcolor: white"]60.00[/TD]
[TD="class: xl78, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"]X[/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Dooley[/TD]
[TD="class: xl66, bgcolor: transparent"]Wed[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl80, bgcolor: #c5d9f1"]3[/TD]
[TD="class: xl75, bgcolor: white"]15.00[/TD]
[TD="class: xl78, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"]X[/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Dooley[/TD]
[TD="class: xl66, bgcolor: transparent"]Wed[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl80, bgcolor: #c5d9f1"]3[/TD]
[TD="class: xl75, bgcolor: white"]45.00[/TD]
[TD="class: xl79, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #d8d8d8"] [/TD]
[TD="class: xl77, bgcolor: transparent"]X[/TD]
[TD="class: xl76, bgcolor: #d8d8d8"] [/TD]
[/TR]
</TBODY>[/TABLE]