# How we can remove zeros before numbers?

##### New Member
Hi, I need help to solve this issue, Like i have to many customer codes and they all have zeros before numbers like,
 Current Shape Required 000003 3 PAK LAND CHEMIST 000005 5 KHALID MEDICAL STORE 000006 6 CHISHTI MEDICAL STORE 000025 25 HASSAN MEDICAL STORE 000076 76 OASIS MEDICAL STORE 000077 77 ISANI MEDICAL STORE 000095 95 AGHA S SUPERMARKET 000100 100 NEW MOTTAS SUPER MARKET 000109 109 IQBAL MEDICAL STORE 000111 111 SALMAN MEDICO 000115 115 NATIONAL CHEMIST 000122 122 KAMAL BAKERY MEDICAL STORE 000123 123 FAZAL-E-RABBI MEDICAL STORE

<colgroup><col><col></colgroup><tbody>
</tbody>

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
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

Use int function
=INT(A2)

1,203,206
Messages
6,054,146
Members
444,703
Latest member
pinkyar23

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back