Date format

[XavierVM]

Hi,


I'm getting a date out of a macro with format 04/05/2015.
I need to have as output 04052015.
Therefore, I've split text to columns which gives me three columns containing a "4", a "5" and a "2015".
I've concatenated these three columns, which gives me 452015. But I need 04052015...


Can someone give some advice ?

Already a big thank you !

Xavier

[Norie]

Can't you use Format?

Please Login or Register  to view this content.

[LJMetzger]

Hi XavierVM and welcome to ExcelForum,

Try something like the following code:

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis

[mahju]

Try

Please Login or Register  to view this content.