I have a spreadsheet, one of the cells has a forumla

that formula has a file name inside somewhere and that filename looks
like this

=Month(Today()) & Year(Today()) & Text(""blah.xls","")

But the month has to have two characters and if the month is less than
10 then it only has one

it should be "03" insead of "3"

anyone know how i can pad out a zero on that?

cheers


--
kickyr
------------------------------------------------------------------------
kickyr's Profile: http://www.excelforum.com/member.php...fo&userid=3388
View this thread: http://www.excelforum.com/showthread...hreadid=514223