Hi Banker,

One way is to divide all your data by 100, by putting 100
in a blank cell, copy it, then select all your data and EditPaste Special
click divide and OK.

Then format them as currency with 2 decimal places
and $ as the symbol.

HTH
Martin