Tag Archives: Format

Adding bullet to each line in cell

Does it sound familiar to you? Are you using Excel as word processing tool? If you have experienced the task shown above, you should know how tedious and time-consuming it could be as you cannot convert each line into bullet … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments

Display single letter Day of week in Excel

Is it achievable?  Not by formatting but formula.

Rate this:

Posted in Format, Formula | Tagged , , , | Leave a comment

Reference to a cell without source number format

You probably knew it… when we make a direct reference to a cell, i.e. input =A1 in A2, the cell A2 will then follow the number format of A1.  Put it in other words, if the number format of A1 is … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Input fraction number in Excel

This title sounds a bit silly,  but I do believe many users must have experienced frustration when they tried to input a fraction number as simple as 1/2 in Excel. When we input something like x/y, Excel assumes that we are … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Show number in thousand (k) or in million (M) by using custom format

The custom format to show number in thousand or in million is simple: #,##0,“k” #,##0,,“M” The “k” or “M” is optional, depend on whether you want to show it in the header or in the figure itself. The trick is … Continue reading

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | 3 Comments

Date Formats – A trick to format date with “st”, “nd”, “rd”, “th”

Well, there is no such custom format for date in Excel… However it can be achieved indirectly, with helper cell 🙂

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 4 Comments

Text Alignment – Fill

We talked about examples of using “Text Alignment – Indent” in the previous post.  In the coming posts, let’s talk about the rest of the less commonly-used text alignments.  Actually, I find it a bit challenging to cite real-life examples … Continue reading

Rate this:

Posted in Format | Tagged , , | 1 Comment

Format part of a formula result… A workaround (non-VBA) solution

How to format part of a formula result? In a normal text string, we may format part of the text to highlight a specific information.  For example, if we input the text string “Today is Thursday, 01/05/2014” in A1, we … Continue reading

Rate this:

Posted in Excel Tips, Format | Tagged , | 6 Comments

Excel Basic – Looks can be deceiving

Once upon a time, I was questioned about the accuracy of calculation in Excel just because one saw a formula “3% x 100” (A1*B1) yielding a result of 2.5 (C1).  WHY???? As a basic but important rule, DO NOT trust … Continue reading

Rate this:

Posted in Excel Basic | Tagged | 1 Comment