Custom Format to display mid numbers

[maabbas]

Is there any way I can custom format the following number to display mid number? please note that i do not want to use Mid function in other cell.

13260109335019670000111000

I just want to display 019.

Thanks in advance.

 

[Rick Rothstein]

Is there any way I can custom format the following number to display mid number? please note that i do not want to use Mid function in other cell.

13260109335019670000111000

I just want to display 019.

Your question is not entirely clear to me. Do you mean you want to make the 019 bold within the same cell the number is in?

Are the numbers in your cells all the same length (26 characters as per your example)?

Do you always want to highlight exactly 3 of the digits as shown in your example?

What is in the cell... the typed-in number of a formula displaying that number?

 

[maabbas]

I just want to display 019 not bold, the characters always 26.

 

[maabbas]

Your question is not entirely clear to me. Do you mean you want to make the 019 bold within the same cell the number is in?

Are the numbers in your cells all the same length (26 characters as per your example)?

Do you always want to highlight exactly 3 of the digits as shown in your example?

What is in the cell... the typed-in number of a formula displaying that number?

cell only has this 26 digit number, we scan the bar code with same length. i just want user to see the mid number i.e. 019, when they scan the bar code.

 

[Rick Rothstein]

cell only has this 26 digit number, we scan the bar code with same length. i just want user to see the mid number i.e. 019, when they scan the bar code.

Where should the user see this... in the same cell highlighted like you showed in your first message or just those three digits in the next cell over?

 

[maabbas]

same cell

 

[Rick Rothstein]

same cell

Okay, in order to bold part of the text, you will need to do that with VBA event code (conditional formatting cannot apply to only part of the text within a cell). In order for me to write the code for you, I need to know what cells to have the event code monitor.

What is the first cell in the range that the bar code will go to?

If other cells can also have bar codes placed in them, I need to know if those cells will only be down the column or only across the row from the starting cell or in a rectangular area originating from that starting cell.

Is there any ending cell beyond which no bar codes are allowed? If so, what cell is it?