Any Office 2010 experts?
Posted: Fri Jan 14, 2011 6:18 pm
Before I hassle Microsoft - and spend a couple of hours in a queue waiting to talk to somebody - I thought I'd ask here first.
I've just started using the latest Office suite and have encountered a date problem. I have an Excel spreadsheet containing dates in the standard UK format - for example 16/3/2011. However, when I try to mailmerge this date into a Word document it comes out in the US format - say, 03/16/2011.
Every date and language option I have (or can find) is set to UK format, in all Office programs and in Windows (7) itself. If I import the Excel file into anything else it remains in the UK format - Access, Notepad. The same data works fine in the entire 2007 Office suite, including Word.
Using 2007 is not an option, though - and I have to run this job at least once a week, every week.
I know I'm clutching at straws - but has anyone else encountered this - and know how to fix it?
Thanks!!
I've just started using the latest Office suite and have encountered a date problem. I have an Excel spreadsheet containing dates in the standard UK format - for example 16/3/2011. However, when I try to mailmerge this date into a Word document it comes out in the US format - say, 03/16/2011.
Every date and language option I have (or can find) is set to UK format, in all Office programs and in Windows (7) itself. If I import the Excel file into anything else it remains in the UK format - Access, Notepad. The same data works fine in the entire 2007 Office suite, including Word.
Using 2007 is not an option, though - and I have to run this job at least once a week, every week.
I know I'm clutching at straws - but has anyone else encountered this - and know how to fix it?
Thanks!!