| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting month padded zero
Or...
=text(today(),"mmyyyy") & .... kickyr wrote: 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 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help!!! Vlookup!! | Excel Worksheet Functions | |||
| Need cell formula to subtotal gross by month for a quarter | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
Threaded Mode
