M
marojave
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.
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.