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
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
If your string is in A1 then
=A1*.01 is what you want.
--
Gary''s Student
"rortiz" wrote:
> 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
This worked great thank you very much
"Gary''s Student" wrote:
> If your string is in A1 then
> =A1*.01 is what you want.
> --
> Gary''s Student
>
>
> "rortiz" wrote:
>
> > 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks