cancel
Showing results for 
Search instead for 
Did you mean: 

How to set cell format as Date

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
------------------------------
2 REPLIES 2

Chakkravarthi_P
Level 3

Hi Ben,

Do have a look here



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

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
------------------------------
-----------------------
If I answered your query. Please mark it as the Best Answer

Harish Mogulluri