How to set cell format as Date

[BenScholefield]

I'm trying to set a column's format as a Date by using the Format Cell object in the extended VBO. Issue I'm having is that I don't know the format parameter for "date". I know that it's "@" for text, "0" for number etc.

Could anyone help pls?

Thanks

------------------------------
Ben Scholefield
------------------------------

[Chakkravarthi_P]

Hi Ben,

Do have a look here

------------------------------
Chakkravarthi. PR
------------------------------

[harish.m]

Hi Ben Scholefield,

Check below article , you can  tweak based on your need Ex: "MM/dd/yyyy"

https://learn.microsoft.com/en-us/office/vba/api/excel.range.numberformat

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------