Format Cell in Excel

Excel Date and Time Functions return a dynamic date or time in a cell.

Sum race time splits in Excel

If you need to add up (sum) up race time splits that are some combination of hours, minutes, and seconds, you can simply use the SUM function. However, you must take care to enter times with the right syntax and use a suitable time format to display results, as explained below. Formula =SUM(range) Explanation The… read more »

Clean and reformat telephone numbers using SUBSTITUTE function in Excel

One way to clean up and reformat telephone numbers is to strip out all extraneous characters, then apply Excel’s built-in telephone number format. Formula =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,”(“,””),”)”,””),”-“,””),” “,””),”.”,””)+0 Note that the cell appears in the middle, with function names above and substitutions below. Not only does this make the formula easier to read, it also makes it… read more »

How to create simple Time Sheet in Excel

This example teaches you how to create a simple timesheet calculator in Excel. Cells that contain formulas are colored light yellow. 1. To automatically calculate the next 4 days and dates when you enter a start date, use the formulas below. 2. Select the cells containing the times. 3. Right click, click Format Cells, and select the right… read more »

Convert Text to Numbers in Excel

By default, text is left-aligned and numbers are right-aligned in Excel. Atimes user enter inverted comma before inputting data values in a cell which automatically converts a number to text. This example teaches you how to convert ‘text strings that represent numbers’ to numbers. 1. Select the range A1:A4 and change the number format to General. 2. Numbers preceded by… read more »

Currency vs Accounting Format in Excel

The Currency format and the Accounting format in Excel are very similar to each other. This example shows the difference. 1. Enter the following values. 2. The Currency format places the dollar sign right next to the number. 3. The Accounting format aligns the dollar signs at the left edge of the cell and displays a dash for zero values. Note:… read more »

Change Fractions Format in Excel

Excel always reduces fractions to its smallest denominator. This example teaches you how to enter a fraction in Excel and how change the format of a fraction. 1. To enter the mixed fraction 1 4/7 (one and four sevenths), type 1 4/7. To enter the fraction 4/7 (four sevenths) into cell A1, select cell A1 and type… read more »

Apply Previous Cell Styles Using Format Painter in Excel

The Format Painter is one of the most underused features of Excel. The Format Painter copies formatting from one place and applies it to another. 1. For example, select cell B2 below.  2. On the Home tab, in the Clipboard group, click Format Painter. A moving dashed border appears around cell B2 and the mouse pointer changes to… read more »

Convert Numbers to Text in Excel

By default, numbers are right-aligned and text is left-aligned in Excel. This example teaches you how to convert numbers to ‘text strings that represent numbers’. 1. Select the range A1:A4 and change the number format  to Text. 2. Precede a number by an apostrophe and it will also be treated as text. 3a. If you add text to a number and… read more »

Merge Cells in Excel

This page illustrates how to merge selected cells into one large cell. Why Merge Cells in Excel? This can be useful if you want to make clear that a label in Excel applies to multiple columns. Before you start: this feature only keeps the value in the upper-left cell and deletes all other values. Go here to concatenate (join) strings in Excel…. read more »

Strikethrough in Excel

Apply or remove strikethrough text formatting This example teaches you how to apply a strikethrough effect to text in Excel. In other words, learn how to draw a line through text in Excel. You can still read text with a strikethrough effect. 1. For example, select the range A2:A4. 2. Right click, and then click Format Cells (or press… read more »