Formating a number as text inside concatenate

[NextYearSox]

I have a series of numbers that are formated as A001, A002, A003, ... , B001, B002, ... , C001, C002, etc. In another cell, I reference one of more of these numbers, and want to maintain the formating. What I'm using is:

=TEXT(B7,"A000")&", "&TEXT(B9,"A000")

This works for 'A' and 'C', but not for 'B', 'D', or 'E'. Not sure why not. Is there a way around this?

 

[texasalynn]

not sure I follow since those are already text?

 

[barry houdini]

You can put a backslash in front of a character to show that you want it to be displayed literally (otherwise it can be mistaken for some other number format, e.g. "D" = day) so try like this

=TEXT(B7,"\B000")&", "&TEXT(B9,"\B000")

 

[NextYearSox]

That is what I was looking for ... thanks!