Thread: [Solved] Date Format Issue
View Single Post
 
Old 06-04-2018, 07:54 AM
Jay_P Jay_P is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2018
Posts: 8
Jay_P is on a distinguished road
Default Date Format Issue

Hi All

Having some issues with a mail merge date format.

My data is coming in as 3/06/18 (D/MM/YY) using format switch DATE \@ "d" \*ordinal DATE \@ "MMMM yyyy which then converts to us format after the switch.

is there away to state that the data is in UK format?

I am using Office 2010

Any help appreciated.

Thanks
Reply With Quote