Combining numbers, text , and numbers with leading 0

kd4dna

New Member
Joined
Jan 12, 2009
Messages
25
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
 

Forum statistics

Threads
1,082,575
Messages
5,366,412
Members
400,888
Latest member
Cdim7

Some videos you may like

This Week's Hot Topics

Top