Change percentage to a five character number but keep the leading zero

[richmcgill]

I need to change a percentage to a number but keep the leading zero.
5.55% would need to be 05550 (I need to keep the leading zero in my final result)
10.05% would look like 10050

Making sense?

 

[richmcgill]

Solution =TEXT(A2*1000,"00000")

 

[Joe4]

Just keep in mind that using the TEXT function returns a string value, and not a numeric one.
That could be problematic if you are trying to use that value in any sort of formulas or calculations.