To complete Progress Bar indicator level to 100% once.

Assume my total Rows are 5000.
While going through each rows counting increase by 1 for displaying
indicator level.
If it reaches 100 it starts again from 1 to display until it completes
5000.

But i don't want to display it again-n-again. Instead to finish it
showing once.
My maths is very poor so i m unable to do the calculation to make it
5000 = 100.

So plz help to complete this indicator level to display 100%
accordingly on completing the total rows


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=471013