Put 100 in a spare cell, select that cell and copy, then select the range of
numbers that you want to change, and Edit/ Paste Special/ Divide/ OK.
After that you can delete the 100 from the spare cell.
--
David Biddulph

Davie B1 wrote:
I entered a number on my worksheet using the $ function. I should
have used the format, cell, currency command. I have enter numbers
like $665 and now want to change all of these to show two decimal
places such as $6.65. How do I change all my numbers I have entered
this way without going back and changing each one individually .
Thank you. Dave