Forum Discussion

Copper Contributor

Nov 30, 2022

Excel VBA fill date as "General" in cell

For example, I need to a cell EXCATLY like this picture. Format must be "General". No ' allowed The reason is I do not know the capture logic of another application, so I have to strictly follow a p...

excel

Macros and VBA

Zach Prins

Brass Contributor

Dec 08, 2022

Hi qazzzlyt,

I tested this code and I think this will give you the result you need

With Cells(x, y)
    .Value = "02/01/2022"
    .NumberFormat = "General"
End With

Regards,

Zach