Need Help with Dates Format Function in VBA

[Helen_Ch]

Hello All,

I need help with format function in VBA to convert date value. Currently, I am pulling data from another sheet in to my main worksheet. Everything looks great except the two columns that has a date does not always show as date. For example, some comes in as 43019 instead of 04/30/2019.

Thank you all!

[Marc L]

Hi !

No need a VBA code, just apply a date format to the cell instead of General format …

[Helen_Ch]

Hi !

No need a VBA code, just apply a date format to the cell instead of General format …

This is part of my automated macro. I created a generate report button so that it would go do its own things like finding values, ranges, etc and i want to include this date format function at the end of my code so that it does it automatically.

[Marc L]

First, do not quote all of any previous post, it's just clutter …

If source data are real dates (so not text) so when using the Range.Copy method the destination cells stay as date !

As a date is stored within Excel as a number only, like for example 43019, if a date appears as a number in a cell
so you just have to apply a date format to the cell, no need to convert it as a date is nothing but a number ‼

Use the VBA NumberFormat cell property and apply the needed date format or just activate the Macro Recorder,
manually update the cell format to a date format : you will get our own code ! …