Custom Cell Formats

[Guest]

Hello,

Have created a validation rule that will "list" specific start times (i.e.
1:00, 1:30, 2:00, etc) with cell formated as "h:mm;@"

I also want the text "Start:" to always appear in front of the listed time
(i.e. Start: 1:00). I also need to show "Start:" in a cell when a time is
not listed in the cell(i.e. "Start:")

I can write a custom cell format "Start:" h:mm;@. But when time is not
entered I have a blank cell. I will always require the text "Start:" in the
cell regardless if a time is listed or not.

Please help,

Beaglemut

 

[Guest]

Use two cells:


Put the validated time enter in the first cell, say A1 and in the other cell:
="Start: " & TEXT(A1,"h:mm;@")

 

[Guest]

Hello,

Thanks, but I need one cell using the validation drop down function and the
word "Start" to appear even if there is no value.

Is there a way to create a custom format to a cell that would maintain a
constant text value even though there is no value entered in the cell?

Chad

 

[Guest]

I am sorry.

It can easily be done with a macro, but I can't do it just with formatting.

Monitor the post in case some else has a better idea.

 

[Guest]

Thanks,

I'm novice with VB, but would tickle the idea. This would need to be a
behind the scences with no manual effort to end users.

Chad