converting number string to number with decimal

[Guest]

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

 

[Guest]

If your string is in A1 then
=A1*.01 is what you want.

 

[Guest]

This worked great thank you very much

If your string is in A1 then
=A1*.01 is what you want.