Create folders macro - with trailing zeros

[mwilkes]

Hi,

I am trying to use a macro to create folders in a directory. This macro works fine, but the folders I need to create contain trailing zeros, example:

00001.002345 - John Doe
00002.003456 - Jane Doe
00003.004567 - John Smith
00004.005678 - Jane Smith

I am able to keep the zeros in place in excel using custom: 00000.000000, but I need to concat the 00000.00000 with the name, (=a1 & " - " & b1).

Here is the code, any suggestions?

Please Login or Register  to view this content.

Crossposted at: http://www.mrexcel.com/forum/excel-q...ml#post3747762

[shg]

Where are the numbers stored? Where are the names?

[mwilkes]

numbers are a1 names are b1, trying to concatenate both to c1. Tried playing with =text but no-go. I really can't concat as b1 & a1.

A1 B1 C1
"00001.002345" "John Doe" "00001.002345 - John Doe"

[shg]

Maybe

Please Login or Register  to view this content.

[mwilkes]

Oh I see what you did there. I'm gonna give this a go, thanks.