How we can remove zeros before numbers?

F

Faryad Gujjar

New Member
Joined
Feb 9, 2019
Messages
1
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
0000033
PAK LAND CHEMIST
0000055
KHALID MEDICAL STORE
0000066
CHISHTI MEDICAL STORE
00002525
HASSAN MEDICAL STORE
00007676
OASIS MEDICAL STORE
00007777
ISANI MEDICAL STORE
00009595
AGHA S SUPERMARKET
000100100
NEW MOTTAS SUPER MARKET
000109109
IQBAL MEDICAL STORE
000111111
SALMAN MEDICO
000115115
NATIONAL CHEMIST
000122122
KAMAL BAKERY MEDICAL STORE
000123123
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.
Sort by date Sort by votes
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
 
Upvote 0
You must log in or register to reply here.

Forum statistics

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

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top