craigos
04-08-2012, 01:14 AM
Hi All,
Home 2007....Work 2003
After much searching I need to ask for help on showing me exactly how to ensure a UK date format is showing on my sheet.
I have a UF with a Textbox where users enter a UK Date as dd/mm/yyyy.
Select Add button and date is sent to sheet but shows as US format - I have to have UK format only.
I have checked Regional settings, looked at many sites giving many many different ways of changing to UK, but alas nothing seems to work....probably my lack of experience!!, I am aware of US Centric for dates in VBA but can't work it out to show UK.
I have attached a much simplfied workbook than my full version in the hope that someone can provide a working example.
In Anticipation
Craig
Home 2007....Work 2003
After much searching I need to ask for help on showing me exactly how to ensure a UK date format is showing on my sheet.
I have a UF with a Textbox where users enter a UK Date as dd/mm/yyyy.
Select Add button and date is sent to sheet but shows as US format - I have to have UK format only.
I have checked Regional settings, looked at many sites giving many many different ways of changing to UK, but alas nothing seems to work....probably my lack of experience!!, I am aware of US Centric for dates in VBA but can't work it out to show UK.
I have attached a much simplfied workbook than my full version in the hope that someone can provide a working example.
In Anticipation
Craig