View Single Post
  #1   Report Post  
rortiz
 
Posts: n/a
Default converting number string to number with decimal

I have a file that contains a number string with leading zeros. I want
convert it to a number and make the last 2 digits cents.

Example:

000000000193506 to 1935.06

Can this be done in Excel