Displaying a "0" when using the TEXT Formula

[Snake Eyes]

How do I display a zero of one of the referenced cells in this formula is a zero?

=TEXT(U50,"##")&" - "&TEXT(U51,"##")&" - "&TEXT(U52,"##")

Presently the display for U51 is a blank when U50= 32 U51= 0 and U52= 8
(32 - - 8)

 

[Fluff]

Use "0" rather than "##"

 

[Snake Eyes]

Hey Fluff,
Interesting. I discounted that because I thought it would always display 0 even if U51 was a number other than 0.
I was wrong.
Thanks for the input.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Scott Huish]

If you have whole numbers in the cell like that already, it seems like this would suffice:
=U50&"-"&U51&"-"&U52