On Dec 24, 9:21*am, "joeu2004" wrote:
"gary c" wrote:
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 " * * * * *")?

=LEFT(C5&REPT(" ",10),10)

You can replace REPT(" ",10) with a string that contains spaces. *I used
REPT for clarity and flexibility.

Thank you, very much.

Now I'll post a new more-complidated question.