C5 has a text format and contains, for example, "04-15-2010" or
"12-02-2002" or is empty.

How do I write a =TEXT function where "value" refers to C5 and "format-
text" returns the contents of C5 with 10-characters (for example:
"04-15-2010" or "12-02-2002" or " ")?