Hi,
In certain cases my textbox will be automatically filled with a date thats been called in the line below
in this cell, the date is set as dd-mm-yyyy but it appears as mm-dd-yyyy in the textbox.
Please Login or Register to view this content.
So in the cell it's like 12-01-2016
When the textbox is filled it changes to 01-12-2016.
How can this be prevented so the textbox will also show the date as dd-mm-yyyy?
Thanks for the help!!
Rrgds,
Crispy
Last edited by Crispy85; 11-02-2016 at 06:41 AM.
Use the cell TEXT property rather than the Value property - this will insert the formatted text as displayed in the cell.
Thanks!
This seems to work!
Nothing to do with your original questionm, but make sure you write it back as a Date and not Text. Excel will try to coerce text that 'looks like' a date to a date using the mm/dd/yy format so you'll end up with American format dates in the cell.
Rather thanUsePlease Login or Register to view this content.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks