Removing zeroes in number format

DebbyH

New Member
Joined
Oct 13, 2015
Messages
8
Our customer numbers begin with A followed by four zeroes and a string of numbers.

Example: A00002121256438
A00002178164211
A00002191112936
A00002152291978


How can I create a formula to remove the 4 zeroes following the letter A so that the output is as follows:

A2121256438
A2178164211
A2191112936
A2152291978

Any assistance would be appreciated.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Agree: no wiggle room to talk about 5, or 6, or 3, or any n≠4 leading zeros. ;)
The OP placed no restrictions on the "string of numbers" that followed the 4 leading zeroes... they could theoretically start with 1 or 2 zeroes (making 5 or 6 leading zeroes) or they could even be all zeroes... all we know about them is they are a string of numbers, nothing more.;)
 
Upvote 0

Forum statistics

Threads
1,216,089
Messages
6,128,760
Members
449,466
Latest member
Peter Juhnke

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