Problem with format

slgknjn · May 23rd, 2005, 02:24 AM

Hi
I am have the following problem with format. Can anyone help?

Here is I want to accomplish.
    DOB = "0507590635"
    txt2.Text = Format(DOB, "######" & "-" & "####")

It should be like this
   txt2.Text ="050759-0635"

But the result is wrong.It gives
    txt2.Text = "50759-0635"

The leading zero disapear.

Any ideas or a different solution.

Thanks in advance
Karsten

marcostraf · May 23rd, 2005, 12:41 PM

Format(dob, "000000" & "-" & "0000")

slgknjn · May 25th, 2005, 08:16 AM

Hi marcostraf
Thanks a lot.

Cheers
Karsten