My first post here, I am a bit nervous.

First off, I consider myself as belonging to the pool of 99% Excel users who use 1% of its power.

Came across this forum the other day and it looked like the right place to ask questions.

Let me begin with the data structure:

ColumnA | ColumnB

AAA | 12345678

BBB | 90123456

I am trying to format the integer numbers in ColumnB in the following way:

If ColumnA reads AAA, add

**TRAILING**zeros to the number in ColumnB of the same row until there are 14 digits there.

If ColumnA reads BBB, add

**LEADING**zeros to the number in ColumnB until there are 10 digits there.

Could you guys/gals give me some examples on how this could be done?

Since there are potentially hundreds of rows that need to be formatted this way, doing this manually is a nightmare.

Thanks in advance