Hi,

I have a large spreadsheet with a column of numbers that need to be changed
to currency. I do not need to add zeros, rather I need to add a decimal to
the middle of the number. For example:

Current Number -- Needs to Be
6640 -- 66.40
1428 -- 14.28
1309 -- 13.09

I have tried checking the "fixed decimal" option which adds a decimal to new
entries, but does not change data that is already entered. I have tried
copying and pasting the column and converting the column to text and
importing it into a new spreadsheet, but Excel still recognizes it as old
data and does not add the decimal.

I have also tried various custom display options such as ##.##, 00.00, ect.

Is there any way I can add a decimal to the existing data or will I have to
retype all of the numbers?

Thank you.