How to set text format for a date in Excel?

[yangyq10 (IvanY)]

Dear Experts

I have a request that column A must be in text format. But at the same time the value must be “MM/dd/yyyy”

I try to put 2 set formats as below: 1st custom 2nd text
But it doesn’t work and result turn to sth like: 45504

Then I try to do it in multiple assignment, but error pop up

May I know how to do?
Thank you for your advise in advance

[Yoichi]

HI,

For now, can you try the following expression?

CDate(row("入金日")).ToString("MM/dd/yyyy")

Regards,

[yangyq10 (IvanY)]

@Yoichi Bingo!! Thank you for you quick solution!!