MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Parsing with Characters

November 15, 2001 - by Bill Jelen

Salim asks:

I have a number with 8 digits. How can I format it to appear as 12/3456/78?

From the menu, select Format - Cells. On the numeric tab, select Custom. In the custom box, type 99\/9999\/99

When you are typing custom number formats, you can insert any single text character by preceeding it with a backslash.

Bill Jelen is the author / co-author of
Excel Subtotals Straight to the Point

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.