Difficulty With Custom Cell Formatting

[Ark68]

I have a column of calculated cells. The formula for the cell in column A is simply (using row 93 as the example)

=B93&C93&"-"&D93

Where B93 = "4A" (value is a mix of number and alphabet), C93 = 01 (value 1, formatted as "00"), and D93 = 01 (value 1, formatted as "00").
For A93, I am looking to achieve a value of "4A01-01". But I'm only getting "4A1-1".

How would I achieve what I am looking for? Would it be to apply a custom format to the entire column? How would that custom format look?

I tried to adjust the formatting in the actual formula, but obviously it didn't work.

= B93&format(C93,"00")&"-"&format(D93,"00))

If the latter is the way to go, where did I go wrong in the formula?

 

[6StringJazzer]

"format" is a VBA function. You should be getting a #NAME! error.

In a worksheet you have to the TEXT function instead. That will do it.

=B93&TEXT(C93,"00")&"-"&TEXT(D93,"00)

Note you also had an extra parenthesis at the end.

 

[Alex Blakenburg]

@6StringJazzer - you are missing a closing " mark at the end. (already missing in Ark68s version)

 

[Ark68]

Thank you both for the prompt assistance. Very much appreciated.