I have received a spreadsheet with hundreds of cells containing "numbers" in
the form 00000000002178 - this is in fact $21.78 but all the cells are set
to General format and the data is not treated as numbers.

Is there an easy way to convert this data into their currency values? I
have tried to set the cells to numerical format with 2 decimal places but
this has no effect on the data. I have to go to each cell, convert the
format and then key in the number - this will take forever.

Hope someone can help

Al