View Single Post
  #1   Report Post  
Jennifer
 
Posts: n/a
Default How do I change a number from 700.00 to 70000 without having to re

I would like to be able to convert a list of numbers from the following
formats 900.00, 40.00, 1.00 etc... to the following format 90000, 4000, 100
etc... without having to re-type the numbers. I need to get rid of the
decimal point but keep the zeros that are after the decimal point. Is there
a function or format that can accomplish this???

Thanks a million for your help!!!