'format' function

[Zxurian]

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.

[kurtsimons]

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)

[Zxurian]

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

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

and 

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

any ideas?

[kurtsimons]

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



MSDN
User-Defined String Formats (Format Function)