How we can remove zeros before numbers?

[Faryad Gujjar]

Hi, I need help to solve this issue, Like i have to many customer codes and they all have zeros before numbers like,
[TABLE="width: 284"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]
Current Shape[/TD]
[TD]
Required[/TD]
[/TR]
[TR]
[TD]000003[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]PAK LAND CHEMIST[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000005[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]KHALID MEDICAL STORE[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000006[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]CHISHTI MEDICAL STORE[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000025[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]HASSAN MEDICAL STORE[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000076[/TD]
[TD="align: right"]76[/TD]
[/TR]
[TR]
[TD]OASIS MEDICAL STORE[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000077[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]ISANI MEDICAL STORE[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000095[/TD]
[TD="align: right"]95[/TD]
[/TR]
[TR]
[TD]AGHA S SUPERMARKET[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000100[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]NEW MOTTAS SUPER MARKET[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000109[/TD]
[TD="align: right"]109[/TD]
[/TR]
[TR]
[TD]IQBAL MEDICAL STORE[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000111[/TD]
[TD="align: right"]111[/TD]
[/TR]
[TR]
[TD]SALMAN MEDICO[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000115[/TD]
[TD="align: right"]115[/TD]
[/TR]
[TR]
[TD]NATIONAL CHEMIST[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000122[/TD]
[TD="align: right"]122[/TD]
[/TR]
[TR]
[TD]KAMAL BAKERY MEDICAL STORE[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]000123[/TD]
[TD="align: right"]123[/TD]
[/TR]
[TR]
[TD]FAZAL-E-RABBI MEDICAL STORE[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

the zeros are due to your numbers being stored as text, in your example if current column is A and Required is be then in B1 =--A1

 

[aqeelnokia99]

Use int function
=INT(A2)