'format' function

does anybody know the format character for 'display if present' ?

Example::

Format("hi","xxxxx") would yield " hi"

what I need the is 'x' that makes that possible, also if there is one for numbers too, that would be great, ex.

Format(32.45,"$99990.00") would yield "$ 32.45"



Thanks in advance.

your second example works like this

Debug.Print Format(32.45, "$0.00")

as for the first I don't know
you could do this to limit the length

debug.print left$("My Text",6)

okay, so I forgot to include the code tags in my first post, here it is again

Code:

---


format("hi","xxxxx") would yield "  hi"

and

format(32.45,"$99990.00") would yield "$  32.45"

---

any ideas?

Format("safdsfd", "@@@@@@@@@@@@@@@@@@")



MSDN
User-Defined String Formats (Format Function)