View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Davie B1 Davie B1 is offline
external usenet poster
 
Posts: 1
Default Change numbers in a worksheet using the $ function.

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