July 2011

Microsoft Query Incompatible with Mac OS X Lion [Updated]

July 12, 2011 Advanced

The other day I read an article on how to prepare my MacBook Pro for Lion, the new Mac OS X coming out this month, and discovered that any application that requires PowerPC is incompatible with Lion and will not work. See update at the end of this post. So I followed the instructions to […]

Get the full story …

International Short Date Formatting for the TEXT Function

July 7, 2011 Advanced

I have an Excel workbook that is used in two different regions where the date format is entirely different, the US and the UK. At the top of a report worksheet I use a TEXT function to inform the user of the date range. Here’s what a US user sees: From: 6/6/2011 to 6/10/2011 Here […]

Related Posts Plugin for WordPress, Blogger...
Get the full story …