Textbox to Cell - Date Format changin

[superdonk]

Hi folks

This one is a head scratcher for me!!

I'm creating a userform that will enter a date into the required cell - quite easy.

however I have come into the office today and found that now, when I enter the date dd/mm/yyyy previously it entered it into the cell as dd/mm/yyyy

Today for some reason its automatically changing it to mm/dd/yyyy!!!

I have made some changes to the code, but nothing that should affect this.

Can you help?!?!?!?

Please Login or Register  to view this content.

[guitarsweety]

Can you attach an example of your file

[nathansav]

Whats the format of the cell that its being put into.

[superdonk]

the format of the cell is dd/mmm/yyyy

its strange - when I enter 05/08/2014 which should be 5th August 2014 - its changing it to 8th May 2014 when it puts it in the cell.

this has only just started to happen.

its also nothing to do with this specific spreadsheet as i tried it in a new workbook and it does the same thing???

I'm guessing its something to do with settings - but i havent a clue where to start!!

[nathansav]

Its american formatting of the date. Check the Locale on the formatting.

[superdonk]

Locale is right - says UK

means it must be something to do with the Userform throwing the information into the cell??

[nathansav]

Try wrapping them in CDATE() or dateserial(year(cdate(textbox1.value)),month(cdate(textbox1.value)),day(cdate(textbox1.value)))

[superdonk]

Works perfect nathansav! thanks very much

but why is it changing it to American style when everything is set up as English(UK)??

bit wierd

[nathansav]

I dont know, it happens sometimes in Access to, there is another compuer setting that may by EN US rather than EN UK.