Custome Format

[martialtiger]

Hi Everyone,

Hope everyone's having a great weekend. I'm stuck at work and needed
little help. Does anyone know if I can create a customer format wher
I can just enter digits and have it show like this: 10:05:23 CH08.
"10:05:23" is the time in military format that I would input, CH is th
text I want to show up all the time and "08" is a number I input a
well.

:

 

[Dave Peterson]

Formatting only?????

If yes, then:

00\:00\:00" CH"00

And just enter 10052308.

Be aware that the underlying value is still 10,052,308.

 

[martialtiger]

Awesome! Thanks Dave. You just helped me cut down my work time! ;