Formatting | Excel Semi-Pro

Formatting

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 […]

Get the full story …

Let Excel Convert Hours Between Two Dates and Times

February 14, 2011 Formatting

In a previous post I went on and on about how you can calculate hours between two different dates and times, but Excel does this for you automatically. I’ll use reader comment as my example. A-02.02.2011 10:00 B-05.02.2011 17:00 Please help me to find B-A in hh:mm For clarity I will assume that the date […]

Get the full story …

Indent Left and Right to Align Cell Contents

December 6, 2010 Beginner

Formatting is second nature with Excel because ergonomically you want people to notice the information in your data and not spend time finding it, either because it doesn’t stand out, or it blurs together. Recently I came across a new wrinkle with the indentation of cell contents and thought to share it with you here. […]

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