Format VB command

[kirkm]

x = "2:01"

debug.print format (x,"0# ##")

I get 00 00

Shouldn't this return

02 01 ??

Thanks - Kirk

 

[Andy Pope]

Hi,

x is representing time so use

format("2:01","hh mm")

Cheers
Andy

 

[Mike H]

Kirk,

What is "2:01" a time?

if so

Debug.Print Format(x, "hh:mm")
returns 02:01

Debug.Print Format(x, "hh mm")
returns 02 01

Mike

 

[kirkm]

Thanks Mike & Andy.

Sanity restored!

Cheers - Kirk