View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hobbi Hobbi is offline
external usenet poster
 
Posts: 2
Default How do you convert existing numbers?

I have a large column of numbers that need to changed to currency. I want to
add decimal points to the amounts already listed, not add decimals and zeros
at the end. Example change 15000 to 150.00 and 1920 to 19.20. Is there a way
to change with without manually doing all the numbers?