Convert String to Currency

AMcLennan 

Select the cells you want to format.

Select currency from the Number Format dropdown on the Home tab of the ribbon.

If that does not help:

Select one column with such cells.

On the Data tab of the ribbon, select Text to Columns, then click Finish.

Repeat for other columns as needed.

Select an empty cell.

Enter 100.

Copy this cell.

Select the cells with values you want to convert.

Right-click anywhere in the selection.

Select Paste Special... from the context menu.

Under Operations, select Divide.

Click OK.

Select Currency from the Number Format dropdown on the Home tab of the ribbon.