Date string auto formatting

[sarafrank.ssf@gmail.com]

Hi,
I'm trying to set date in CellRange, I set for example:
range.Value = "08/09/2016"
But it automatic write in the range: "08/09/2016 12:00:00 AM", and I don't find a way to force it to write my original date?
(I don't set the NumberFormat or set the cell to be a date cell because I string another text to the cell after)
Thank you!
Sara.

[Betsy.jiang]

Dear Sara,

Thanks for your inquiry.
Please try to use following code to solve this issue.

Code: Select all

sheet.Range["A3"].Text = "08/09/2016";

If there is any question, welcome to get it back to us.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Dear Sara,

Did you test the code ? Has your issue been resolved ?

Thanks,
Betsy
E-iceblue support team

[sarafrank.ssf@gmail.com]

Hi,
It was solved!!
Thank you!!!
Sara.

by the way, I didn't get any announcement that you answered, so only now I saw the message...
sorry I didn't answer before!

[Betsy.jiang]

Dear Sara,

Thanks for your feedback.
Welcome to write to us for further question. We are here for help.

Sincerely,
Betsy
E-iceblue support team