Add Zeros to a Sequence but not if the number is 1 thru 9 (any number but zero)

rebel123

Active Member
Joined
Apr 18, 2017
Messages
363
Office Version
  1. 365
Platform
  1. MacOS
The correct answers are in green. I just need an equals sign formula for the correct answer, please.

Add Zeros to a Sequence but not if the number is 1 thru 9 (any number but zero)
 

Attachments

  • Screenshot 2025-03-25 at 12.49.48 PM.jpg
    Screenshot 2025-03-25 at 12.49.48 PM.jpg
    89.7 KB · Views: 12
0101 1 60101160000000000
0113 6 31130060000000003
11H 1703 A 211H01703000A002
0121 11 91210110000000009
0121 12 21210120000000002
128E28 16128E280000000016
 
Upvote 0
0101 1 60101160000000000
0113 6 31130060000000003
11H 1703 A 211H01703000A002
0121 11 91210110000000009
0121 12 21210120000000002
128E28 16128E280000000016
 
Upvote 0
honestly I am also not sure if the answer is 1 equation, 2 equations, or 3. Here are the other scenarios.
Scenario 1 would be the initial question which is 1 formula.
Scenario 2 would be 3 different formulas.
Scenario 3 would be where the top part has 1 formula but the bottom 2 have their own formula.
 

Attachments

  • Screenshot 2025-03-25 at 1.16.58 PM.jpg
    Screenshot 2025-03-25 at 1.16.58 PM.jpg
    153.4 KB · Views: 8
Upvote 0
I fail to see/understand the logic to be applied, especially since there are discrepancies in your examples.
For example, in some screen prints you show it should be:
0101100000000006
for the first one, and in others you show:
0101160000000000

So which one is it? Which do you want?

I think it would be most beneficial if you walked through each of the examples you have posted, and tell us exactly how to get to the final result that you want, as I am not seeing any consistent predictable pattern.
 
Upvote 0

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