Hi

I'm creating an Excel converter app, which reads data from client's forecast file, and writes a text file used to import those data to ERP program.

I tried in VBA procedure to convert date to string, using code like:
where strDateformat is "dd/mm/yyyy" (it is read from Setup sheet of converter, i.e. user can determine, what the format must be). The local date format for my computer is "dd.mm.yyyy", and this is the format the VBA returns. (And this is really what the Format() function returns - I checked it in Immediate window!). So what about Format function converting the date to string in given format?