Combining numbers, text , and numbers with leading 0

[kd4dna]

I must be missing something, I just can figure out what.

I'm trying to combine a two digit date, i.e. "dd" followed by / then 4 digit hour (which is a number)

=text(today(), "dd") & "/" & CO23 (where my hour number is in cell CO23) except when the value in CO23 is <1000. I'd like a leading 0, i.e. 22/0400.

I tried to custom format the cell that contains the above formula, no luck. Tried custom formating the cell which contains the original hour value. That works in the original cell (i.e.CO23) but not when it's combined.

What am I missing?

Ron
kd4dna

 

[mikerickson]

Try
=TEXT(TODAY(), "dd") & "/" & TEXT(CO23,"0000")

("0000" are zeros)

 

[kd4dna]

That works great! Thanks!

Ron
kd4dna