topic How to set cell format as Date in Product Forum

How to set cell format as Date

Ben_Scholefield_Everflow — Fri, 27 Oct 2023 10:25:00 GMT

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

RE: How to set cell format as Date

Chakkravarthi_P — Fri, 27 Oct 2023 11:01:00 GMT

Hi Ben,

Do have a look here

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

RE: How to set cell format as Date

harish.mogulluri — Fri, 27 Oct 2023 15:53:00 GMT

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